Changeset 3425553

Timestamp:

12/22/2025 05:44:40 PM (2 months ago)

Author:

facturaone

Message:

v4.58

File:

• wp-facturaone/trunk/wp-facturaone.php (modified) (7 diffs)

wp-facturaone/trunk/wp-facturaone.php

@@ -4 +4 @@
 Plugin URI: https://www.facturaone.com/
 Description: La forma más fácil de trabajar con tu tienda online desde nuestro ERP FacturaONE.
-Version: 4.56
+Version: 4.58
 Author: FacturaONE
 Author URI: https://www.facturaone.com/
@@ -353 +353 @@
     if ($mod_wordpress <= 0) {return 0;} 
 
-    $_product_id = (int) fone_get_product_id_by_idfactura($item_lookup_id);
+    $_product_id = (int) fone_get_product_id_by_idfactura($item_lookup_id,$item_sku);
     $itemnameorig=$item_name;
     
@@ -2910 +2910 @@
  * - PHP 7.4 compatible
  */
-function fone_get_product_id_by_idfactura($idfactura){
+function fone_get_product_id_by_idfactura($idfactura,$sku=''){
     $idfactura = trim((string)$idfactura);
+    $sku       = trim((string)$sku);
     if ($idfactura === '') return 0;
 
-    $cache_key = 'fone_idfactura_' . md5($idfactura);
+    $cache_key = 'fone_idfactura_' . md5($idfactura.'|'.$sku);
 
     // OJO: si cachea 0, no retornamos todavía (evita duplicados)
@@ -2923 +2924 @@
 
     global $wpdb;
+    $found = 0;
 
     // 1) Buscar por meta fone_idfactura (lógica ERP)
-    $sql = "
+    $found = (int)$wpdb->get_var($wpdb->prepare("
         SELECT p.ID
         FROM {$wpdb->posts} p
@@ -2935 +2937 @@
         ORDER BY p.post_type ASC, p.ID DESC
         LIMIT 1
-    ";
-    $found = (int) $wpdb->get_var($wpdb->prepare($sql, 'fone_idfactura', $idfactura));
+    ", 'fone_idfactura', $idfactura));
 
     // 2) Fallback: probar como post_id (más directo en 1 query)
@@ -2942 +2943 @@
         $pid = (int)$idfactura;
         if ($pid > 0) {
-            $found = (int) $wpdb->get_var($wpdb->prepare(
+            $found = (int)$wpdb->get_var($wpdb->prepare(
                 "SELECT ID FROM {$wpdb->posts}
-                 WHERE ID=%d AND post_type IN ('product','product_variation')
+                 WHERE ID=%d 
+                    AND post_type IN ('product','product_variation')
+                    AND post_status IN ('publish','draft','private','pending')
                  LIMIT 1",
                 $pid
@@ -2950 +2953 @@
         }
     }
-
-    // Cachea resultado final
-    wp_cache_set($cache_key, (int)$found, 'fone', 300);
+    
+    // 3) sku
+    if ($found <= 0 && $sku !== '') {
+        $lookup_table = $wpdb->prefix . 'wc_product_meta_lookup';
+        static $has_lookup = null;
+
+        if ($has_lookup === null) {
+            $has_lookup = ($wpdb->get_var($wpdb->prepare("SHOW TABLES LIKE %s", $lookup_table)) === $lookup_table);
+        }
+
+        if ($has_lookup) {
+            $found = (int)$wpdb->get_var($wpdb->prepare(
+                "SELECT product_id FROM {$lookup_table} WHERE sku = %s LIMIT 1",
+                $sku
+            ));
+        }
+
+        if ($found <= 0) {
+            $found = (int)$wpdb->get_var($wpdb->prepare(
+                "SELECT p.ID
+                 FROM {$wpdb->posts} p
+                 INNER JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID
+                 WHERE pm.meta_key = '_sku'
+                   AND pm.meta_value = %s
+                   AND p.post_type IN ('product','product_variation')
+                   AND p.post_status IN ('publish','draft','private','pending')
+                 ORDER BY p.post_type ASC, p.ID DESC
+                 LIMIT 1",
+                $sku
+            ));
+        }
+
+        if ($found <= 0) {
+            $found = (int)$wpdb->get_var($wpdb->prepare(
+                "SELECT p.ID
+                 FROM {$wpdb->posts} p
+                 INNER JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID
+                 WHERE pm.meta_key = '_sku'
+                   AND LOWER(pm.meta_value) = LOWER(%s)
+                   AND p.post_type IN ('product','product_variation')
+                   AND p.post_status IN ('publish','draft','private','pending')
+                 ORDER BY p.post_type ASC, p.ID DESC
+                 LIMIT 1",
+                $sku
+            ));
+        }
+    }
+    
+    // cache solo si hay resultado
+    if ($found > 0) {
+        wp_cache_set($cache_key, (int)$found, 'fone', 300);
+    }
 
     return (int)$found;
 }
 function fone_get_variation_id_by_idfactura($idfactura){
-    global $wpdb;
-    $idfactura = trim((string)$idfactura);
-    if ($idfactura==='') return 0;
-
-    // Cache
-    $cache_key = 'fone_variation_idfactura_' . md5($idfactura);
-    $cached = wp_cache_get($cache_key, 'fone');
-    if ($cached !== false && (int)$cached > 0) {
-        return (int)$cached;
-    }
-    
-    // 1) Buscar por meta fone_idfactura (lógica ERP)
-    $sql = "
-        SELECT p.ID
-        FROM {$wpdb->posts} p
-        INNER JOIN {$wpdb->postmeta} pm ON pm.post_id=p.ID
-        WHERE pm.meta_key=%s
-          AND pm.meta_value=%s
-          AND p.post_type='product_variation'
-          AND p.post_status IN ('publish','draft','private','pending')
-        ORDER BY p.ID DESC
-        LIMIT 1
-    ";
-    //return (int)$wpdb->get_var($wpdb->prepare($sql,'fone_idfactura',$idfactura));
-    $found = (int) $wpdb->get_var(
-        $wpdb->prepare($sql, 'fone_idfactura', $idfactura)
-    );
-    
-    
-    // 2) Fallback: tratar idfactura como post_id (solo si numérico)
-    if ($found <= 0 && ctype_digit($idfactura)) {
-        $pid = (int) $idfactura;
-        if ($pid > 0) {
-            $post_type = (string) $wpdb->get_var(
-                $wpdb->prepare(
-                    "SELECT post_type FROM {$wpdb->posts} WHERE ID = %d LIMIT 1",
-                    $pid
-                )
-            );
-            if ($post_type === 'product_variation') {
-                $found = $pid;
-            }
-        }
-    }
-
-    // Cachear resultado final (incluye 0)
-    wp_cache_set($cache_key, (int) $found, 'fone', 300);
-
-    return (int) $found;   
-}
-
+    $id = (int) fone_get_product_id_by_idfactura($idfactura, '');
+    if ($id <= 0) return 0;
+    return (get_post_type($id) === 'product_variation') ? $id : 0;
+}