Changeset 2547408

Timestamp:

06/14/2021 11:07:43 AM (5 years ago)

Author:

phcwordpress

Message:

upd 14062021

File:

• drivefx-woocommerce/trunk/class.DriveFxWoocommerce.php (modified) (7 diffs)

drivefx-woocommerce/trunk/class.DriveFxWoocommerce.php

@@ -1693 +1693 @@
         //Add products from Phc in online shop
         function addProduct($nomeProduct, $contentProduct, $excerptProduct, $slugNameProduct, $stockUnitsProduct, $price, $sku, $manageStock, $visible, $thumb_url){
+
             $settings = get_option(DRIVEFXWOOCOMMERCE_PLUGIN_NAME);
             global $wpdb;
@@ -1706 +1707 @@
 
             //make product type be variable:
-            wp_set_object_terms ($new_post_id,'simple','product_type');
+            wp_set_object_terms($new_post_id,'simple','product_type');
 
             //set product values:
@@ -1715 +1716 @@
             }
 
-            update_post_meta( $new_post_id, '_sku', $sku);
+            update_post_meta( $new_post_id, '_sku', $sku);
             update_post_meta( $new_post_id, '_visibility', $visible);
             update_post_meta( $new_post_id, '_price', $price );
@@ -1916 +1917 @@
                                 foreach ($response['result'] as $key => $value) {
 
+                                    # get the list of products by sku, from "wp_postmeta" table (already imported)
+                                    global $wpdb;
+                                    $product_id = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $response['result'][$key]['ref'] ) );
+
+                                    //$this->logs->writeFileLog('product_id:', $product_id);
+
                                     //Create Table
                                     $tableProducts .= "<tr>";
-                                    if(wc_get_product_id_by_sku( $response['result'][$key]['ref'] )== ""){
+                                    //if(wc_get_product_id_by_sku($response['result'][$key]['ref'])== ""){    // -- temporary deprecated !!!
+                                    if($product_id == ""){
                                         if($arrayRef[$response['result'][$key]['ref']] < 0){
+
                                             $tableProducts .= "<td style='text-align: left;'><input type='checkbox' disabled name='checkboxes' value='".$response['result'][$key]['ref']."'></td>";
                                         } else {
@@ -2191 +2200 @@
                             ++$i;
                         }
-                           //If exists selected products
-                            foreach ($refArray as $prod) {
-                                //Obtain post_id of postmeta table
-                                $productID = wc_get_product_id_by_sku($prod['sku']);
-
-                                //Obtain products
-                                if(!empty($productID)){
-                                        if($settings['backend']['manageStock'] == 'on'){
-                                            update_post_meta($productID,'_stock',$prod['stock']);
-
-                                            if($prod['stock'] > 0){
-                                                update_post_meta( $productID, '_stock_status', 'instock');
-
-                                            } else {
-                                                //update_post_meta( $productID, '_stock_status', 'outofstock');
-                                            }
-                                        }
+                        //If exists selected products
+                        foreach ($refArray as $prod) {
+                            //Obtain post_id of postmeta table
+                            //$productID = wc_get_product_id_by_sku($prod['sku']); -- temporary deprecated !!!
+
+                            # get the product ID by sku (ref) directly from wp_postmeta table
+                            global $wpdb;
+                            $productID = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $prod['sku'] ) );
+
+                            //Obtain products
+                            if(!empty($productID)){
+                                if($settings['backend']['manageStock'] == 'on'){
+                                    update_post_meta($productID,'_stock',$prod['stock']);
+
+                                    if($prod['stock'] > 0){
+                                        update_post_meta( $productID, '_stock_status', 'instock');
+
+                                    } else {
+                                        //update_post_meta( $productID, '_stock_status', 'outofstock');
                                     }
-
-
-                            }
-
-
+                                }
+                            }
+                        }
                     }
                 }
@@ -2290 +2299 @@
                         //Update all prices in Woocommerce
                         foreach($values_touse as $key => $values){
-                            $productID = wc_get_product_id_by_sku($key);
+                            //$productID = wc_get_product_id_by_sku($key);  - temporary deprecated
+
+                            # get the product ID by sku (ref) directly from wp_postmeta table
+                            global $wpdb;
+                            $productID = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $key ) );
+
                             update_post_meta( $productID, '_price', $values[$settings['backend']['productPriceColumn']] );
                             update_post_meta( $productID, '_regular_price', $values[$settings['backend']['productPriceColumn']]);
@@ -2446 +2460 @@
 
                         foreach($values_touse as $key => $values){
-                                $productID = wc_get_product_id_by_sku($key);
+                                //$productID = wc_get_product_id_by_sku($key);  -- temporary deprecated !!!
+
+                                # get the product ID by sku (ref) directly from wp_postmeta table
+                                global $wpdb;
+                                $productID = $wpdb->get_var( $wpdb->prepare( "SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_sku' AND meta_value='%s' LIMIT 1", $key));
+
                                 update_post_meta($productID,'_stock',$values['stock']);