Changeset 2856209

Timestamp:

01/28/2023 09:55:13 AM (3 years ago)

Author:

holest

Message:

Fix import/export settings save problem.

Location:

excel-like-price-change-for-woocommerce-and-wp-e-commerce-light/trunk

Files:

• excel-like-price-change-for-woocommerce-and-wp-e-commerce-light.php (modified) (2 diffs)
• lib/script.js (modified) (1 diff)
• lib/settings_panel.php (modified) (1 diff)
• readme.txt (modified) (1 diff)
• shops/wooc.php (modified) (3 diffs)

excel-like-price-change-for-woocommerce-and-wp-e-commerce-light/trunk/excel-like-price-change-for-woocommerce-and-wp-e-commerce-light.php

@@ -7 +7 @@
  * Plugin URI: https://holest.com/spreadsheet-price-changer-for-woocommerce-and-wp-e-commerce
  * Description:An WooCommerce / WP E-commerce 'MS excel'-like fast input spreadsheet editor for fast product price change using web-form spreadsheet or export / import form CSV. It supports both WooCommerce and WP E-commerce. UI behaves same as in MS Excel. This is the right thing for you if your users give you a blank stare when you're trying to explain them how to update prices.;EDITABLE / IMPORTABLE FIELDS: Price, Sales Price; VIEWABLE / EXPORTABLE FIELDS: WooCommerce: Price, Sales Price, Attributes (Each pivoted as column), SKU, Category, Shipping class, Name, Slug, Stock, Featured, Status, Weight, Height, Width, Length, Tax status, Tax class; WP E-commerce: Price, Sales Price, Tags, SKU, Category, Name, Slug, Stock, Status, Weight, Height, Width, Length, Taxable, local and international shipping costs; Allows custom fields you can configure to view/export any property
- * Tested up to: 6.1.0
- * Version: 2.2.25
+ * Tested up to: 6.1.1
+ * Version: 2.3.0
  * Author: Holest Engineering
  * Author URI: http://www.holest.com
  * Requires at least: 3.6
  * WC requires at least: 2.5.0
- * WC tested up to: 6.5.1
+ * WC tested up to: 7.3.0
  * License: GPLv2
  * Tags: csv, import, excel, export, bulk, fast, woo, woocommerce, products, editor, spreadsheet 
@@ -228 +228 @@
             if(current_user_can('administrator')) {
                 if (!wp_verify_nonce($_POST['pelm_nonce_check'], 'pelm_update_settings')) { 
-                    die("<br><br>PELM PRICE CSRF: Hmm .. looks like you didn't send any credentials.. No access for you!");
+                    die("<br><br>PELM PRICE CSRF: Hmm .. looks like you didn't send correct credentials.. No access for you!");
                 }
 

excel-like-price-change-for-woocommerce-and-wp-e-commerce-light/trunk/lib/script.js

@@ -26 +26 @@
 });
 
+function pelm_do_load(withImportSettingsSave,attach_properties){
+    pending_load++;
+    try{
+        if(pending_load < 6){
+            var n = 0;
+            for(var key in tasks){
+                if(tasks.hasOwnProperty(key))
+                    n++;
+            }
+                
+            if(n > 0) {
+              setTimeout(function(){
+                pelm_do_load();
+              },2000);
+              return;
+            }
+        }
+    }catch(ex){
+        pending_load = 0;
+    }
+
+    var POST_DATA = {pelm_nonce_check: jQuery("input[name='pelm_nonce_check']:last").val(), pelm_security: jQuery("input[name='pelm_security']:last").val() };
+    
+    POST_DATA.sortOrder            = DG.sortOrder ? "ASC" : "DESC";
+    POST_DATA.sortColumn           = pelm_get_sort_property();
+    POST_DATA.limit                = jQuery('#txtlimit').val();
+    POST_DATA.page_no              = jQuery('#paging_page').val();
+    
+    jQuery('.filter_option *[name]').each(function(ind){
+        POST_DATA[jQuery(this).attr("name")] = jQuery(this).val();
+    });
+    
+    if(typeof attributes !== 'undefined'){
+        for(var index in attributes){
+            if(attributes.hasOwnProperty(index)){
+                POST_DATA["pattribute_" + attributes[index].id] = jQuery('.filter_option *[name="pattribute_' + attributes[index].id + '"]').val();
+            }
+        }
+    }
+    
+    if(typeof custom_fields !== 'undefined'){
+        for(var index in custom_fields){
+            if(custom_fields.hasOwnProperty(index)){
+                if(custom_fields[index].type == "term"){
+                    POST_DATA[custom_fields[index].name] = jQuery('.filter_option *[name="' + custom_fields[index].name + '"]').val();
+                }
+            }
+        }
+    }
+    
+    if(attach_properties){
+        for(var aprop in attach_properties){
+            if(attach_properties.hasOwnProperty(aprop)){
+                POST_DATA[aprop] = attach_properties[aprop];
+            }
+        }
+    }
+
+    jQuery('#operationFRM').empty();
+    jQuery('#operationFRM').append(jQuery("<input type='hidden' name='elpm_shop_com' value='wooc' />"));
+    
+    for(var key in POST_DATA){
+        if(POST_DATA.hasOwnProperty(key)){
+            if(POST_DATA[key])
+                jQuery('#operationFRM').append("<INPUT type='hidden' name='" + key + "' value='" + POST_DATA[key] + "' />");
+        }
+    }
+    
+    if(withImportSettingsSave){
+      var settings = {};
+      jQuery('#settings-panel INPUT[name],#settings-panel TEXTAREA[name],#settings-panel SELECT[name]').each(function(i){
+        if(jQuery(this).attr('type') == "checkbox")
+            settings[jQuery(this).attr('name')] = jQuery(this)[0].checked ? 1 : 0;
+        else
+            settings[jQuery(this).attr('name')] = jQuery(this).val() instanceof Array ? jQuery(this).val().join(",") : jQuery(this).val(); 
+      });
+      settings.save_import_settings = 1;
+      
+      for(var key in settings){
+          if(settings.hasOwnProperty(key)){
+              var inp = jQuery("<INPUT type='hidden' />");
+              inp.attr("name", key);
+              inp.attr("value",settings[key]);
+              jQuery('#operationFRM').append(inp);
+          }
+      }
+    }
+    
+    jQuery('#operationFRM').submit();
+}
+
+window.doLoad = pelm_do_load;
+
 function pelm_store_state(){
     if(!window.pelm_localStorage_clear_flag){

excel-like-price-change-for-woocommerce-and-wp-e-commerce-light/trunk/lib/settings_panel.php

@@ -54 +54 @@
   
 ?>
+<input name="pelm_nonce_check" type="hidden" value="<?php echo esc_attr(wp_create_nonce('pelm_update_settings')); ?>" />
+<input name="pelm_security" type="hidden" value="<?php echo esc_attr(pelm_get_nonce("pelm_nonce")); ?>" />
+
 <div id="settings-panel" style="display:none;">
 <div>

excel-like-price-change-for-woocommerce-and-wp-e-commerce-light/trunk/readme.txt

@@ -5 +5 @@
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
 Stable tag: 2.2.25
-Tested up to: 6.1.0
+Tested up to: 6.1.1
 WC requires at least: 2.5.0
-WC tested up to: 6.5.1
+WC tested up to: 7.3.0
 Tags: excel, csv, import, export, woo, woocommerce, wpsc, ecommerce, e-commerce, wp-e-commerce, spreadsheet, product, editor, fast, easy, bulk, bulk edit, import products, export products
 Plugin URI: https://holest.com/spreadsheet-price-changer-for-woocommerce-and-wp-e-commerce

excel-like-price-change-for-woocommerce-and-wp-e-commerce-light/trunk/shops/wooc.php

@@ -1624 +1624 @@
 $_num_sample = (1/2).'';
 $args = array(
-     'post_type' => array('product')
+     'post_type' => array('product','product_variation')
     ,'posts_per_page' => -1
     ,'ignore_sticky_posts' => true
@@ -1701 +1701 @@
 
 if($sku) {
-    $meta_query[] =    array(
-                        'key' => '_sku',
-                        'value' => $sku,
+    $meta_query[] = array(
+                        'key'     => '_sku',
+                        'value'   => $sku,
                         'compare' => 'LIKE'
                     );
@@ -1767 +1767 @@
     $variat_ids = $wpdb->get_col(
         $wpdb->prepare( 
-            "SELECT      p.ID
-            FROM        $wpdb->posts p
-         WHERE       p.post_type = 'product_variation'
-                        AND 
-                     p.post_parent = %d
-         ORDER BY    p.ID
+            "SELECT 
+                p.ID
+             FROM  
+                $wpdb->posts p
+             WHERE  
+                (p.post_type = 'product_variation' AND  p.post_parent = %d)
+             ORDER BY    p.ID
         ",
-            $p_id
+         $p_id
+         ,
+         $p_id
         )
     );