<?php
// Get all products
$args = array(
    'post_type' => 'product',
    'posts_per_page' => -1,
    'post_status' => 'publish'
);

$products = get_posts($args);
$meta_keys = array('_stock_warehouse_5', '_stock_warehouse_6');
$results = array();

foreach ($products as $product) {
    $product_obj = wc_get_product($product->ID);
    
    // Check if it's a variable product
    if ($product_obj->is_type('variable')) {
        $variations = $product_obj->get_available_variations();
        
        foreach ($variations as $variation) {
            $variation_id = $variation['variation_id'];
            
            // Check each meta key
            foreach ($meta_keys as $meta_key) {
                $meta_value = get_post_meta($variation_id, $meta_key, true);
                
                if ($meta_value !== '' && $meta_value !== false) {
                    $results[] = array(
                        'product_title' => $product->post_title,
                        'variation_id' => $variation_id,
                        'variation_label' => implode(', ', $variation['attributes']),
                        'meta_key' => $meta_key,
                        'meta_value' => $meta_value
                    );
                }
            }
        }
    }
    
    // Also check simple products (just in case)
    foreach ($meta_keys as $meta_key) {
        $meta_value = get_post_meta($product->ID, $meta_key, true);
        
        if ($meta_value !== '' && $meta_value !== false) {
            $results[] = array(
                'product_title' => $product->post_title,
                'variation_id' => 'N/A (Simple Product)',
                'variation_label' => 'N/A',
                'meta_key' => $meta_key,
                'meta_value' => $meta_value
            );
        }
    }
}

// Output HTML
?>

<div class="audit-summary">
    <strong>Total Results Found:</strong> <?php echo count($results); ?>
</div>

<?php if (count($results) > 0): ?>
    <table class="audit-table">
        <thead>
            <tr>
                <th>Product Title</th>
                <th>Variation ID</th>
                <th>Variation Label</th>
                <th>Meta Key</th>
                <th>Meta Value</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($results as $result): ?>
                <tr>
                    <td><?php echo esc_html($result['product_title']); ?></td>
                    <td><?php echo esc_html($result['variation_id']); ?></td>
                    <td><?php echo esc_html($result['variation_label']); ?></td>
                    <td><?php echo esc_html($result['meta_key']); ?></td>
                    <td><?php echo esc_html($result['meta_value']); ?></td>
                </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
<?php else: ?>
    <p>No products or variations found with the specified meta keys.</p>
<?php endif; ?>

.audit-table {
  width: 100%;
  border-collapse: collapse;
  margin: 20px 0;
}
.audit-table th,
.audit-table td {
  border: 1px solid #ddd;
  padding: 12px;
  text-align: left;
}
.audit-table th {
  background-color: #f4f4f4;
  font-weight: bold;
}
.audit-table tr:nth-child(even) {
  background-color: #f9f9f9;
}
.audit-summary {
  margin: 20px 0;
  padding: 15px;
  background-color: #e7f3ff;
  border-left: 4px solid #2196F3;
}