Changeset 3436129

Timestamp:

01/09/2026 04:47:27 PM (6 weeks ago)

Author:

rermis

Message:

v5.0.23 = * Updates to handle null variation meta

Location:

pb-shipping/tags/5.0.23

Files:

• . (copied) (copied from pb-shipping/trunk)
• pb_functions.php (copied) (copied from pb-shipping/trunk/pb_functions.php) (3 diffs)
• pb_queue.php (copied) (copied from pb-shipping/trunk/pb_queue.php) (2 diffs)
• pb_report.php (copied) (copied from pb-shipping/trunk/pb_report.php)
• pb_ship.php (copied) (copied from pb-shipping/trunk/pb_ship.php)
• readme.txt (copied) (copied from pb-shipping/trunk/readme.txt) (2 diffs)

pb-shipping/tags/5.0.23/pb_functions.php

@@ -6 +6 @@
 Author: RLDD
 Author URI: https://richardlerma.com/contact/
-Version: 5.0.22
+Version: 5.0.23
 Copyright: (c) 2020-2026 rldd.net - All Rights Reserved
 License: GPLv3 or later
@@ -14 +14 @@
 */
 
-global $espb_version; $espb_version='5.0.22';
+global $espb_version; $espb_version='5.0.23';
 if(!defined('ABSPATH')) exit;
 
@@ -752 +752 @@
   $weight_unit=get_option('woocommerce_weight_unit');
   $product_lookup='wp_wc_order_product_lookup';
-  $meta_subquery="(SELECT CONCAT('<div class=\'meta\'>',GROUP_CONCAT(DISTINCT CONCAT(UCASE(SUBSTRING(m.meta_key,1,1)),SUBSTRING(m.meta_key,2),':',m.meta_value) SEPARATOR ' | '),'</div>') FROM wp_wc_order_product_lookup pl JOIN wp_woocommerce_order_itemmeta m ON m.order_item_id=pl.order_item_id WHERE pl.order_item_id=po.order_item_id AND pl.variation_id=IFNULL(NULLIF(po.variation_id,0),po.product_id) AND m.meta_key NOT LIKE '\_%' AND m.meta_value IS NOT NULL)";
+  $meta_subquery="IFNULL((SELECT CONCAT('<div class=\'meta\'>',GROUP_CONCAT(DISTINCT CONCAT(UCASE(SUBSTRING(m.meta_key,1,1)),SUBSTRING(m.meta_key,2),':',m.meta_value) SEPARATOR ' | '),'</div>') FROM wp_wc_order_product_lookup pl JOIN wp_woocommerce_order_itemmeta m ON m.order_item_id=pl.order_item_id WHERE pl.order_item_id=po.order_item_id AND pl.variation_id=IFNULL(NULLIF(po.variation_id,0),po.product_id) AND m.meta_key NOT LIKE '\_%' AND m.meta_key!='Backordered' AND m.meta_value IS NOT NULL),'')";
   if($post_type=='import_order') {
     $product_lookup='wp_import_order_product_lookup';
-    $meta_subquery="(SELECT CONCAT('<div class=\'meta\'>',post_excerpt,'</div>') FROM wp_posts WHERE ID=NULLIF(po.variation_id,0))";
+    $meta_subquery="IFNULL((SELECT CONCAT('<div class=\'meta\'>',post_excerpt,'</div>') FROM wp_posts WHERE ID=NULLIF(po.variation_id,0)),'')";
   }
   

pb-shipping/tags/5.0.23/pb_queue.php

@@ -97 +97 @@
           ,IFNULL((SELECT meta_value FROM wp_postmeta WHERE post_id=o.ID AND meta_key='shipping' LIMIT 1),(SELECT order_item_name FROM wp_woocommerce_order_items WHERE order_id=o.ID AND order_item_type='shipping' LIMIT 1))method
           ,(SELECT NULLIF(m.meta_value,0) FROM wp_woocommerce_order_items oi JOIN wp_woocommerce_order_itemmeta m ON m.order_item_id=oi.order_item_id AND m.meta_key='cost' WHERE oi.order_id=o.ID AND oi.order_item_type='shipping' LIMIT 1)cost
-          ,IFNULL((SELECT GROUP_CONCAT(DISTINCT CONCAT(UCASE(SUBSTRING(m.meta_key,1,1)),SUBSTRING(m.meta_key,2),': ',m.meta_value) SEPARATOR '
') FROM wp_wc_order_product_lookup pl JOIN wp_woocommerce_order_itemmeta m ON m.order_item_id=pl.order_item_id WHERE pl.order_id=o.ID AND pl.variation_id=COALESCE(NULLIF(op.variation_id,0),ip.variation_id,0) AND m.meta_key NOT LIKE '\_%' AND m.meta_value IS NOT NULL),(SELECT post_excerpt FROM wp_posts WHERE ID=COALESCE(NULLIF(op.variation_id,0),ip.variation_id,0)))meta
+          ,IFNULL((SELECT GROUP_CONCAT(DISTINCT CONCAT(UCASE(SUBSTRING(m.meta_key,1,1)),SUBSTRING(m.meta_key,2),': ',m.meta_value) SEPARATOR '
') FROM wp_wc_order_product_lookup pl JOIN wp_woocommerce_order_itemmeta m ON m.order_item_id=pl.order_item_id WHERE pl.order_id=o.ID AND pl.variation_id=COALESCE(NULLIF(op.variation_id,0),ip.variation_id,0) AND m.meta_key NOT LIKE '\_%' AND m.meta_key!='Backordered' AND m.meta_value IS NOT NULL),(SELECT post_excerpt FROM wp_posts WHERE ID=COALESCE(NULLIF(op.variation_id,0),ip.variation_id,0)))meta
           ,(SELECT meta_value FROM wp_postmeta WHERE meta_key='delivery_est' AND post_id=o.ID LIMIT 1)delivery_est
           FROM wp_posts o 
@@ -165 +165 @@
           ,IFNULL((SELECT meta_value FROM wp_postmeta WHERE post_id=o.ID AND meta_key='shipping' LIMIT 1),(SELECT order_item_name FROM wp_woocommerce_order_items WHERE order_id=o.ID AND order_item_type='shipping' LIMIT 1))method
           ,(SELECT NULLIF(m.meta_value,0) FROM wp_woocommerce_order_items oi JOIN wp_woocommerce_order_itemmeta m ON m.order_item_id=oi.order_item_id AND m.meta_key='cost' WHERE oi.order_id=o.ID AND oi.order_item_type='shipping' LIMIT 1)cost
-          ,IFNULL((SELECT GROUP_CONCAT(DISTINCT CONCAT(UCASE(SUBSTRING(m.meta_key,1,1)),SUBSTRING(m.meta_key,2),': ',m.meta_value) SEPARATOR '
') FROM wp_wc_order_product_lookup pl JOIN wp_woocommerce_order_itemmeta m ON m.order_item_id=pl.order_item_id WHERE pl.order_id=o.ID AND pl.variation_id=COALESCE(NULLIF(op.variation_id,0),ip.variation_id,0) AND m.meta_key NOT LIKE '\_%' AND m.meta_value IS NOT NULL),(SELECT post_excerpt FROM wp_posts WHERE ID=COALESCE(NULLIF(op.variation_id,0),ip.variation_id,0)))meta
+          ,IFNULL((SELECT GROUP_CONCAT(DISTINCT CONCAT(UCASE(SUBSTRING(m.meta_key,1,1)),SUBSTRING(m.meta_key,2),': ',m.meta_value) SEPARATOR '
') FROM wp_wc_order_product_lookup pl JOIN wp_woocommerce_order_itemmeta m ON m.order_item_id=pl.order_item_id WHERE pl.order_id=o.ID AND pl.variation_id=COALESCE(NULLIF(op.variation_id,0),ip.variation_id,0) AND m.meta_key NOT LIKE '\_%' AND m.meta_key!='Backordered' AND m.meta_value IS NOT NULL),(SELECT post_excerpt FROM wp_posts WHERE ID=COALESCE(NULLIF(op.variation_id,0),ip.variation_id,0)))meta
           ,(SELECT meta_value FROM wp_postmeta WHERE meta_key='delivery_est' AND post_id=o.ID LIMIT 1)delivery_est
           FROM wp_posts o 

pb-shipping/tags/5.0.23/readme.txt

@@ -6 +6 @@
 Requires at least: 4.6
 Tested up to: 6.9
-Stable tag: 5.0.22
+Stable tag: 5.0.23
 
 A streamlined US shipping solution for WooCommerce and Pitney Bowes.
@@ -37 +37 @@
 
 == Changelog ==
+= 5.0.23 = * Updates to handle null variation meta
 = 5.0.22 = * Improvements to queue and fetch tracking status
 = 5.0.21 = * Queue updates and aesthetic improvements