Context Navigation

← Previous Changeset
Next Changeset →

Changeset 2437678

Timestamp:

12/11/2020 08:28:15 PM (5 years ago)

Author:

skynetsolutions

Message:

1.1.15 - Updated stock settings to load WooCommerce product and update stock using built in WooComerce Product Class instead of manually updating wp_post_meta.

Location:

midwest-logistics/trunk

Files:

: 3 edited

inc/setupFunctions.php (modified) (198 diffs)
midwest-wholesale.php (modified) (1 diff)
readme.txt (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed

midwest-logistics/trunk/inc/setupFunctions.php

-                      r2313232
+                      r2437678
 /* Does User Belong Here */
 …
 if ( ! defined( 'MIDWESTLOGISTICS_VERSION' ) ) {
 …
     header( 'Status: 403 Forbidden' );
 …
     header( 'HTTP/1.1 403 Forbidden' );
 …
     exit();
 …
+}
 …
 function midwest_logistics_initialize() {
 …
     //Do we need to update the db table?
 …
     if( empty(get_option( 'midwest_logistics_db_version' )) || get_option( 'midwest_logistics_db_version' ) !== '1.1' ){
 …
         //Run any updates for table or option settings here. It will be ran when the plugin updates.
 …
+    }
 …
     if (!in_array( 'woocommerce/woocommerce.php', apply_filters( 'active_plugins', get_option( 'active_plugins' ) ) ) ) {
 …
         add_action( 'admin_notices', 'midwest_logistics_no_woo' );
 …
         $MIDWESTLOGISTICS_activated = false;
 …
+    }
 …
+}
 …
 function midwest_logistics_activate() {
 …
     if (in_array( 'woocommerce/woocommerce.php', apply_filters( 'active_plugins', get_option( 'active_plugins' ) ) ) ) {
 …
         midwest_logistics_create_table();
 …
         midwest_logistics_create_order_table();
 …
         //set up the scheduler stock update
 …
         if ( ! wp_next_scheduled( 'midwest_logistics_inventory_stock_update' ) ) {
 …
             wp_schedule_event(time(), 'hourly', 'midwest_logistics_inventory_stock_update');
 …
+        }
 …
         //set up the scheduler for the tracking information
 …
         if ( ! wp_next_scheduled( 'midwest_logistics_update_tracking_information' ) ) {
 …
             wp_schedule_event(time(), 'hourly', 'midwest_logistics_update_tracking_information');
 …
+        }
 …
         midwest_logistics_revert_update_partial_orders();
 …
         update_option( 'midwest_logistics_db_version', '1.1' );
 …
         $MIDWESTLOGISTICS_activated = true;
 …
+    }
 …
+}
 …
 function midwest_logistics_deactivate() {
 …
     wp_clear_scheduled_hook('midwest_logistics_inventory_stock_update');
 …
     wp_clear_scheduled_hook('midwest_logistics_update_tracking_information');
 …
     midwest_logistics_update_partial_orders();
 …
+}
 …
 function midwest_logistics_unistall() {
 …
     midwest_logistics_delete_table();
 …
     delete_option("midwest_logistics_settings");
 …
     delete_option("midwest_logistics_db_version");
 …
     //wp_clear_scheduled_hook('midwest_logistics_inventory_stock_update');
 …
     //wp_clear_scheduled_hook('midwest_logistics_update_tracking_information');
 …
+}
 …
 /*
 …
 * Registers the scripts needed for the Midwest Woocommerce.
 …
 */
 …
 add_action( 'admin_enqueue_scripts', 'midwest_logistics_admin_script' );
 …
 function midwest_logistics_admin_script($hook) {
 …
     wp_enqueue_script( 'midwest_logistics_admin_script', plugin_dir_url( __FILE__ )   . '../scripts/admin.js', false, '1.0.0' );
 …
+}
 …
 function midwest_logistics_warn_phpversion() {
 …
     ?>
 …
     <div class="notice-error notice is-dismissible">
 …
         <p><strong><?php _e( "PHP version 5.3.0 is required to run this plugin.",MIDWESTLOGISTICS_NAME); ?></strong></p>
 …
     </div>
 …
     <?php
 …
+}
 …
 function midwest_logistics_no_woo() {
 …
     if (! in_array( 'woocommerce/woocommerce.php', apply_filters( 'active_plugins', get_option( 'active_plugins' ) ) ) ) {
 …
         ?>
 …
         <div class="notice-error notice is-dismissible">
 …
             <p><strong><?php _e( "Woocommerce is required to run the " . MIDWESTLOGISTICS_NAME ." plugin. Please install or activate Woocommerce.",MIDWESTLOGISTICS_NAME); ?></strong></p>
 …
         </div>
 …
         <?php
 …
+    }
 …
 …
+}
 …
 function  midwest_logistics_no_api() {
 …
     $settingsOptions = get_option( 'Midwest_Logistics_settings' );
 …
     $apiKey = "";
 …
     $customerId = "";
 …
     $settingOptions = get_option('Midwest_Logistics_settings','');
 …
     if($settingOptions !== "") {
 …
         $apiKey = $settingOptions["Midwest_Logistics_API_Key_field_0"];
 …
         $customerId = $settingOptions["Midwest_Logistics_customer_id_text_field_1"];
 …
+    }
 …
     if ($apiKey === "" || $customerId === "") {
 …
         ?>
 …
         <div class="notice-error notice is-dismissible">
 …
             <p><strong><?php _e( "An API key and customer id is required before " . MIDWESTLOGISTICS_NAME . " plugin can be used.",MIDWESTLOGISTICS_NAME); ?></strong></p>
 …
         </div>
 …
         <?php
 …
+    }
 …
+}
 …
 //this must be set for the wp scheduler to work.
 …
 add_action( 'midwest_logistics_inventory_stock_update', 'midwest_logistics_inventory_stock_update' );
 …
 function midwest_logistics_inventory_stock_update() {
 …
     $settingsOptions = get_option( 'Midwest_Logistics_settings' );
 …
     if($settingsOptions['Midwest_Logistics_select_field_1'] == "2" || $settingsOptions['Midwest_Logistics_select_field_1'] == "") {
 …
         //if the dropdown is set to no don't worry about it.
 …
         return;
 …
+    }
 …
     $apiKey = "";
 …
     $settingOptions = get_option('Midwest_Logistics_settings','');
 …
     if($settingOptions !== "") {
 …
         $apiKey = $settingOptions["Midwest_Logistics_API_Key_field_0"];
 …
+    }
 …
 …
     //simple Products
 …
     $args = array(
 …
         'posts_per_page'   => 10000,
 …
         'offset'           => 0,
 …
         'category'         => '',
 …
         'category_name'    => '',
 …
         'orderby'          => 'date',
 …
         'order'            => 'DESC',
 …
         'include'          => '',
 …
         'exclude'          => '',
 …
         'meta_key'         => '_midwest_logistics_product_select',
 …
         'meta_value'       => 'Y',
 …
         'post_type'        => 'product',
 …
         'post_mime_type'   => '',
 …
         'post_parent'      => '',
 …
         'author'       => '',
 …
         'author_name'      => '',
 …
         'post_status'      => 'publish',
 …
         'suppress_filters' => true
 …
     );
 …
     $posts_array = get_posts( $args );
 …
     foreach ( $posts_array as $post) : setup_postdata( $posts_array );
 …
         //simple product
 …
         if(get_post_meta($post->ID, '_manage_stock', true ) === "yes") {
 …
             $SKUNumber = get_post_meta($post->ID, '_midwest_logistics_product_sku_text_field', true );
 …
             if($SKUNumber !== "") {
 …
                 $jsonArray = [
 …
                     "apiKey" => $apiKey,
 …
                     "sku" => $SKUNumber,
 …
                     "request" => "productcheck"
 …
                 ];
 …
                 $postString = json_encode ($jsonArray);
 …
                 $args = array(
 …
                     'body' => $postString,
 …
                     'timeout' => '60',
 …
                     'redirection' => '5',
 …
                     'httpversion' => '1.0',
 …
                     'blocking' => true,
 …
                     'headers' => array(),
 …
                     'cookies' => array()
 …
                 );
 …
 …
                 $wp_remote_post_response = wp_remote_post( MIDWESTLOGISTICS_API_URL,$args);
 …
                 if(is_wp_error($wp_remote_post_response)) {
 …
                     $httpcode = "500";
 …
                     $code = $wp_remote_post_response->get_error_code();
 …
                     $response = $wp_remote_post_response->get_error_messages($code);
 …
                     if(is_array($response)) {
 …
                         $response = $response[0];
 …
+                    }
 …
 …
                 } else {
 …
                     $httpcode = wp_remote_retrieve_response_code( $wp_remote_post_response );
 …
                     $response = $wp_remote_post_response["body"];
 …
+                }
 …
 …
                 //$ch = curl_init( MIDWESTLOGISTICS_API_URL );
 …
                 //curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
 …
                 //curl_setopt($ch, CURLOPT_POSTFIELDS, $postString);
 …
                 //curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
 …
                 //$response =  curl_exec( $ch );
 …
                 //$httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
 …
                 if($httpcode == "200") {
 …
                     $responseArray = midwest_logistics_inventory_json_parse($response);
 …
                     if(is_array($responseArray)) {
 …
                         if($responseArray["result"] = "200") {
 …
                             $stockAmount = $responseArray["stockAmount"];
 …
                             $inStock = $responseArray["instock"];
 …
                             $responseText = $inStock;
 …
+                            if($inStock = "Y") {
+                                if(is_numeric($stockAmount) ) {
+                                    //update_post_meta( $post->ID, '_stock_status', esc_attr( "instock") );
+                                    update_post_meta( $post->ID, '_stock', esc_attr( $stockAmount) );
+                                }
+                            } else {
+                                //update_post_meta( $post->ID, '_stock_status', esc_attr( "outofstock") );
+                                update_post_meta( $post->ID, '_stock', esc_attr( $stockAmount) );
+                            if(is_numeric($stockAmount) ) {
+                                $product = new WC_Product( $post->ID );
+                                $product->set_stock_quantity($stockAmount);
+                                $product->save();
+                            }
+                        }
+                    }
+                }
+                if($httpcode == "500") {
+                    new WP_Error(  MIDWESTLOGISTICS_NAME . ' API',MIDWESTLOGISTICS_NAME . " API is down." );
+                    $responseArray =  array("result" => false, "message" => MIDWESTLOGISTICS_NAME . " API is down.");
+                }
+                //add the log
+                midwest_logistics_add_communication_log($postString,$response,$post->ID,"product",get_the_title(),$responseText);
+            }
+        }
+    endforeach;
+    //variable products
+    $args = array(
+        'posts_per_page'   => 10000,
+        'offset'           => 0,
+        'category'         => '',
+        'category_name'    => '',
+        'orderby'          => 'date',
+        'order'            => 'DESC',
+        'include'          => '',
+        'exclude'          => '',
+        'meta_key'         => '_midwest_logistics_product_select',
+        'meta_value'       => 'Y',
+        'post_type'        => 'product_variation',
+        'post_mime_type'   => '',
+        'post_parent'      => '',
+        'author'       => '',
+        'author_name'      => '',
+        'post_status'      => 'publish',
+        'suppress_filters' => true
+    );
+    $posts_array = get_posts( $args );
+    foreach ( $posts_array as $post) : setup_postdata( $posts_array );
+        if(get_post_meta($post->ID, '_manage_stock', true ) === "yes") {
+            $SKUNumber = get_post_meta($post->ID, '_midwest_logistics_product_sku_text_field', true );
+            if($SKUNumber !== "") {
+                $jsonArray = [
+                    "apiKey" => $apiKey,
+                    "sku" => $SKUNumber,
+                    "request" => "productcheck"
+                ];
+                $postString = json_encode ($jsonArray);
+                $args = array(
+                    'body' => $postString,
+                    'timeout' => '60',
+                    'redirection' => '5',
+                    'httpversion' => '1.0',
+                    'blocking' => true,
+                    'headers' => array(),
+                    'cookies' => array()
+                );
+                $wp_remote_post_response = wp_remote_post( MIDWESTLOGISTICS_API_URL,$args);
+                if(is_wp_error($wp_remote_post_response)) {
+                    $httpcode = "500";
+                    $code = $wp_remote_post_response->get_error_code();
+                    $response = $wp_remote_post_response->get_error_messages($code);
+                    if(is_array($response)) {
+                        $response = $response[0];
+                    }
+                } else {
+                    $httpcode = wp_remote_retrieve_response_code( $wp_remote_post_response );
+                    $response = $wp_remote_post_response["body"];
+                }
+                //$ch = curl_init( MIDWESTLOGISTICS_API_URL );
+                //curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
+                //curl_setopt($ch, CURLOPT_POSTFIELDS, $postString);
+                //curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
+                //$response =  curl_exec( $ch );
+                //$httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
+                if($httpcode == "200") {
+                    $responseArray = midwest_logistics_inventory_json_parse($response);
+                    if(is_array($responseArray)) {
+                        if($responseArray["result"] = "200") {
+                            $stockAmount = $responseArray["stockAmount"];
+                            $inStock = $responseArray["instock"];
+                            $responseText = $inStock;
+                            if(is_numeric($stockAmount) ) {
+                                $product =  wc_get_product($post->ID);
+                                $product->set_stock_quantity($stockAmount);
+                                $product->save();
+                            }
 …
+                        }
 …
+                    }
 …
+                }
 …
                 if($httpcode == "500") {
 …
                     new WP_Error(  MIDWESTLOGISTICS_NAME . ' API',MIDWESTLOGISTICS_NAME . " API is down." );
 …
                     $responseArray =  array("result" => false, "message" => MIDWESTLOGISTICS_NAME . " API is down.");
 …
+                }
 …
                 //add the log
 …
                 midwest_logistics_add_communication_log($postString,$response,$post->ID,"product",get_the_title(),$responseText);
 …
+            }
 …
+        }
 …
+    endforeach;
+    //variable products
+    $args = array(
+        'posts_per_page'   => 10000,
+        'offset'           => 0,
+        'category'         => '',
+        'category_name'    => '',
+        'orderby'          => 'date',
+        'order'            => 'DESC',
+        'include'          => '',
+        'exclude'          => '',
+        'meta_key'         => '_midwest_logistics_product_select',
+        'meta_value'       => 'Y',
+        'post_type'        => 'product_variation',
+        'post_mime_type'   => '',
+        'post_parent'      => '',
+        'author'       => '',
+        'author_name'      => '',
+        'post_status'      => 'publish',
+        'suppress_filters' => true
+    );
+    $posts_array = get_posts( $args );
+    foreach ( $posts_array as $post) : setup_postdata( $posts_array );
+        if(get_post_meta($post->ID, '_manage_stock', true ) === "yes") {
+            $SKUNumber = get_post_meta($post->ID, '_midwest_logistics_product_sku_text_field', true );
+            if($SKUNumber !== "") {
+                $jsonArray = [
+                    "apiKey" => $apiKey,
+                    "sku" => $SKUNumber,
+                    "request" => "productcheck"
+                ];
+                $postString = json_encode ($jsonArray);
+                $args = array(
+                    'body' => $postString,
+                    'timeout' => '60',
+                    'redirection' => '5',
+                    'httpversion' => '1.0',
+                    'blocking' => true,
+                    'headers' => array(),
+                    'cookies' => array()
+                );
+                $wp_remote_post_response = wp_remote_post( MIDWESTLOGISTICS_API_URL,$args);
+                if(is_wp_error($wp_remote_post_response)) {
+                    $httpcode = "500";
+                    $code = $wp_remote_post_response->get_error_code();
+                    $response = $wp_remote_post_response->get_error_messages($code);
+                    if(is_array($response)) {
+                        $response = $response[0];
+                    }
+    endforeach;
+}
+//add_action( 'wp_loaded', 'midwest_logistics_inventory_stock_update' );
+function midwest_logistics_inventory_json_parse($json) {
+    if(json_decode($json) !== null) {
+        $jsonResponse = json_decode($json);
+        $curl_result = $jsonResponse -> {"result"};
+        if($curl_result === "200") {
+            $responseArray = array("result" => true, "message" => $jsonResponse -> {"message"}, "stockAmount" => $jsonResponse -> {"stock"}, "instock" => $jsonResponse -> {"instock"});
+        } else {
+            $responseArray =  array("result" => false, "message" => $jsonResponse -> {"message"}, "stockAmount" => "0", "instock" => "N");
+        }
+    } else {
+        new WP_Error(  MIDWESTLOGISTICS_NAME . ' API',"Invalid Call" );
+        $responseArray =   array("result" => false, "message" => "Invalid Call", "stockAmount" => "0", "instock" => "N");
+    }
+    return $responseArray;
+}
+function midwest_logistics_create_table() {
+    global $wpdb;
+    $table_name = $wpdb->prefix . MIDWESTLOGISTICS_TABLE_NAME;
+    $charset_collate = $wpdb->get_charset_collate();
+    $sql = "CREATE TABLE $table_name (
+        id bigint(9) NOT NULL AUTO_INCREMENT,
+        dateadded datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
+        JSONsent text NOT NULL,
+        JSONresponse text NOT NULL,
+        post_id bigint NOT NULL,
+        post_meta_key varchar(255),
+        post_meta_value longtext,
+        response varchar(255),
+        PRIMARY KEY  (id)
+    ) $charset_collate;";
 …
+                } else {
+                    $httpcode = wp_remote_retrieve_response_code( $wp_remote_post_response );
+                    $response = $wp_remote_post_response["body"];
+                }
+                //$ch = curl_init( MIDWESTLOGISTICS_API_URL );
+                //curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
+                //curl_setopt($ch, CURLOPT_POSTFIELDS, $postString);
+                //curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
+                //$response =  curl_exec( $ch );
+                //$httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
+                if($httpcode == "200") {
+                    $responseArray = midwest_logistics_inventory_json_parse($response);
+                    if(is_array($responseArray)) {
+                        if($responseArray["result"] = "200") {
+                            $stockAmount = $responseArray["stockAmount"];
+                            $inStock = $responseArray["instock"];
+                            $responseText = $inStock;
+                            if($inStock = "Y") {
+                                if(is_numeric($stockAmount) ) {
+                                    //update_post_meta( $post->ID, '_stock_status', esc_attr( "instock") );
+                                    update_post_meta( $post->ID, '_stock', esc_attr( $stockAmount) );
+                                }
+                            } else {
+                                //update_post_meta( $post->ID, '_stock_status', esc_attr( "outofstock") );
+                                update_post_meta( $post->ID, '_stock', esc_attr( $stockAmount) );
+                            }
+                        }
+                    }
+                }
+                if($httpcode == "500") {
+                    new WP_Error(  MIDWESTLOGISTICS_NAME . ' API',MIDWESTLOGISTICS_NAME . " API is down." );
+                    $responseArray =  array("result" => false, "message" => MIDWESTLOGISTICS_NAME . " API is down.");
+                }
+                //add the log
+                midwest_logistics_add_communication_log($postString,$response,$post->ID,"product",get_the_title(),$responseText);
+            }
+        }
+    endforeach;
+    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
+    dbDelta( $sql );
 …
+function midwest_logistics_inventory_json_parse($json) {
+    if(json_decode($json) !== null) {
+        $jsonResponse = json_decode($json);
+        $curl_result = $jsonResponse -> {"result"};
+        if($curl_result === "200") {
+            $responseArray = array("result" => true, "message" => $jsonResponse -> {"message"}, "stockAmount" => $jsonResponse -> {"stock"}, "instock" => $jsonResponse -> {"instock"});
+        } else {
+            $responseArray =  array("result" => false, "message" => $jsonResponse -> {"message"}, "stockAmount" => "0", "instock" => "N");
+        }
+    } else {
+        new WP_Error(  MIDWESTLOGISTICS_NAME . ' API',"Invalid Call" );
+        $responseArray =   array("result" => false, "message" => "Invalid Call", "stockAmount" => "0", "instock" => "N");
+    }
+    return $responseArray;
+function midwest_logistics_create_order_table() {
+    global $wpdb;
+    $table_name = $wpdb->prefix . "midwest_logistics_orders";
+    $charset_collate = $wpdb->get_charset_collate();
+    $sql = "CREATE TABLE $table_name (
+        id bigint(9) NOT NULL AUTO_INCREMENT,
+        post_id bigint,
+        initial_status varchar(255),
+        changed_to_status varchar(255),
+        PRIMARY KEY  (id)
+    ) $charset_collate;";
+    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
+    dbDelta( $sql );
 …
+function midwest_logistics_create_table() {
+function midwest_logistics_delete_table() {
 …
+    $table_name = $wpdb->prefix . MIDWESTLOGISTICS_TABLE_NAME;
+    $charset_collate = $wpdb->get_charset_collate();
+    $sql = "CREATE TABLE $table_name (
+        id bigint(9) NOT NULL AUTO_INCREMENT,
+        dateadded datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
+        JSONsent text NOT NULL,
+        JSONresponse text NOT NULL,
+        post_id bigint NOT NULL,
+        post_meta_key varchar(255),
+        post_meta_value longtext,
+        response varchar(255),
+        PRIMARY KEY  (id)
+    ) $charset_collate;";
+    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
+    dbDelta( $sql );
+    $table_name = $wpdb->prefix . MIDWESTLOGISTICS_TABLE_NAME;
+    $sql = "DROP TABLE IF EXISTS $table_name";
+    $wpdb->query($sql);
+    $table_name = $wpdb->prefix . "midwest_logistics_orders";
+    $sql = "DROP TABLE IF EXISTS $table_name";
+    $wpdb->query($sql);
 …
+function midwest_logistics_create_order_table() {
+function midwest_logistics_update_partial_orders() {
 …
+    $table_name = $wpdb->prefix . "midwest_logistics_orders";
+    $charset_collate = $wpdb->get_charset_collate();
+    $sql = "CREATE TABLE $table_name (
+        id bigint(9) NOT NULL AUTO_INCREMENT,
+        post_id bigint,
+        initial_status varchar(255),
+        changed_to_status varchar(255),
+        PRIMARY KEY  (id)
+    ) $charset_collate;";
+    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
+    dbDelta( $sql );
+    $table_name = $wpdb->prefix . "posts";
+    $order_table_name = $wpdb->prefix . "midwest_logistics_orders";
+    $orderArray = [];
+    $sql = "INSERT INTO $order_table_name
+            (post_id,initial_status,changed_to_status)
+            SELECT wP.ID,post_status,'wc-processing'
+            FROM $table_name wP
+            WHERE post_status = 'wc-partial-shipped'
+            AND post_type='shop_order'; ";
+    $wpdb->query($sql);
+    $sql = "UPDATE wp_posts SET post_status = 'wc-processing'
+            WHERE ID IN (
+                SELECT post_id
+                FROM wp_midwest_logistics_orders
+            )
+            AND post_status = 'wc-partial-shipped'
+            AND post_type='shop_order'; ";
+    $wpdb->query($sql);
 …
+function midwest_logistics_delete_table() {
+function midwest_logistics_revert_update_partial_orders() {
 …
+    $table_name = $wpdb->prefix . MIDWESTLOGISTICS_TABLE_NAME;
+    $sql = "DROP TABLE IF EXISTS $table_name";
+    $table_name = $wpdb->prefix . "posts";
+    $order_table_name = $wpdb->prefix . "midwest_logistics_orders";
+    $orderArray = [];
+    $sql = "UPDATE $table_name SET post_status = 'wc-partial-shipped'
+            WHERE ID IN (
+                SELECT post_id
+                FROM $order_table_name
+            )
+            AND post_status = 'wc-processing'
+            AND post_type='shop_order';";
 …
+    $table_name = $wpdb->prefix . "midwest_logistics_orders";
+    $sql = "DROP TABLE IF EXISTS $table_name";
+    $sql = "DELETE FROM $order_table_name;";
 …
+}
 …
-function midwest_logistics_update_partial_orders() {
-    global $wpdb;
-    $table_name = $wpdb->prefix . "posts";
-    $order_table_name = $wpdb->prefix . "midwest_logistics_orders";
-    $orderArray = [];
-    $sql = "INSERT INTO $order_table_name
-            (post_id,initial_status,changed_to_status)
-            SELECT wP.ID,post_status,'wc-processing'
-            FROM $table_name wP
-            WHERE post_status = 'wc-partial-shipped'
-            AND post_type='shop_order'; ";
-    $wpdb->query($sql);
-    $sql = "UPDATE wp_posts SET post_status = 'wc-processing'
-            WHERE ID IN (
-                SELECT post_id
-                FROM wp_midwest_logistics_orders
+            )
-            AND post_status = 'wc-partial-shipped'
-            AND post_type='shop_order'; ";
-    $wpdb->query($sql);
+}
-function midwest_logistics_revert_update_partial_orders() {
-    global $wpdb;
-    $table_name = $wpdb->prefix . "posts";
-    $order_table_name = $wpdb->prefix . "midwest_logistics_orders";
-    $orderArray = [];
-    $sql = "UPDATE $table_name SET post_status = 'wc-partial-shipped'
-            WHERE ID IN (
-                SELECT post_id
-                FROM $order_table_name
+            )
-            AND post_status = 'wc-processing'
-            AND post_type='shop_order';";
-    $wpdb->query($sql);
-    $sql = "DELETE FROM $order_table_name;";
-    $wpdb->query($sql);
+}
 …
 //function debug_me() {
 …
 //    var_dump(wp_next_scheduled( 'midwest_logistics_inventory_stock_update' ));
 …
 //}
 …
 //add_action( 'wp_loaded', 'midwest_logistics_inventory_stock_update' );
 …

midwest-logistics/trunk/midwest-wholesale.php

-                      r2383128
+                      r2437678
     * Plugin URI:  https://plugins.skynet-solutions.net/
     * Description: Midwest Wholesale Plugin allows you to automatically add Woocommerce orders into the Midwest Logistics order system.
     * Version:     1.1.14
+    * Version:     1.1.15
     * WC requires at least: 3.0.0
     * WC tested up to: 4.5.1
+    * WC tested up to: 4.8.0
     * Author:      Skynet Solutions Inc.
     * Author URI:  http://www.skynet-solutions.net/

midwest-logistics/trunk/readme.txt

-                      r2383128
+                      r2437678
 Tags: Midwest Logistics, Distribution, Shipping
 Requires at least: 4.0
 Tested up to: 5.3.2
+Tested up to: 5.6.0
 Requires PHP: 5.4
 Stable tag: 1.1.14
+Stable tag: 1.1.15
 License: GPLv3

Note: See TracChangeset for help on using the changeset viewer.

Trac UI Preferences

Plugin Directory