Time Filter Debug Eszköz

    Time Filter Debug Információk

    get_results(”
    SELECT DISTINCT meta_key
    FROM {$wpdb->postmeta}
    WHERE meta_key LIKE ‘%upload%’
    OR meta_key LIKE ‘%time%’
    OR meta_key LIKE ‘%date%’
    LIMIT 20
    “);

    echo ‘

    1. Kapcsolódó meta kulcsok az adatbázisban:

    ‘;
    echo ‘

      ‘;
      foreach ($meta_keys as $key) {
      echo ‘

    • ' . esc_html($key->meta_key) . '

      • ‘;
      }
      echo ‘

    ‘;

    // 2. Ellenőrizzük a _product_upload_date értékeket
    $date_values = $wpdb->get_results(”
    SELECT
    pm.meta_value,
    COUNT(*) as count
    FROM {$wpdb->postmeta} pm
    INNER JOIN {$wpdb->posts} p ON p.ID = pm.post_id
    WHERE pm.meta_key = ‘_product_upload_date’
    AND p.post_type = ‘product’
    AND p.post_status = ‘publish’
    GROUP BY pm.meta_value
    ORDER BY pm.meta_value DESC
    LIMIT 10
    “);

    echo ‘

    2. _product_upload_date értékek (első 10):

    ‘;
    if ($date_values) {
    echo ‘

    ‘;
    echo ‘

    ‘;
    foreach ($date_values as $value) {
    $timestamp = intval($value->meta_value);
    $date_str = $timestamp > 0 ? date(‘Y-m-d H:i:s’, $timestamp) : ‘Invalid’;
    echo ‘

    ‘;
    echo ‘

    ‘;
    echo ‘

    ‘;
    echo ‘

    ‘;
    echo ‘

    ‘;
    }
    echo ‘

    Érték Dátum Termékek száma
    ‘ . esc_html($value->meta_value) . ‘ ‘ . esc_html($date_str) . ‘ ‘ . esc_html($value->count) . ‘

    ‘;
    } else {
    echo ‘

    NINCS _product_upload_date meta adat!

    ‘;
    }

    // 3. Példa termékek
    $sample_products = $wpdb->get_results(”
    SELECT p.ID, p.post_title
    FROM {$wpdb->posts} p
    WHERE p.post_type = ‘product’
    AND p.post_status = ‘publish’
    ORDER BY p.ID DESC
    LIMIT 5
    “);

    echo ‘

    3. Legutóbbi 5 termék részletei:

    ‘;
    foreach ($sample_products as $product) {
    echo ‘

    ‘;
    echo ‘Termék #’ . $product->ID . ‘: ‘ . esc_html($product->post_title) . ‘
    ‘;

    // Főkép info
    $thumbnail_id = get_post_thumbnail_id($product->ID);
    if ($thumbnail_id) {
    $attachment_path = get_attached_file($thumbnail_id);
    $filename = basename($attachment_path);
    echo ‘Főkép fájlnév: ' . esc_html($filename) . '
    ‘;

    // Ellenőrizzük a mintát
    if (preg_match(‘/(\d{4})-(\d{2})-(\d{2})-(\d{2})-(\d{2})-(\d{2})/’, $filename, $matches)) {
    echo ‘✓ Dátum található a fájlnévben
    ‘;
    } else {
    echo ‘✗ Nincs dátum a fájlnévben
    ‘;
    }
    } else {
    echo ‘Nincs főkép beállítva
    ‘;
    }

    // Meta adatok
    $upload_date = get_post_meta($product->ID, ‘_product_upload_date’, true);
    $upload_timeframe = get_post_meta($product->ID, ‘_product_upload_timeframe’, true);

    echo ‘_product_upload_date: ' . ($upload_date ? $upload_date . ' (' . date('Y-m-d H:i:s', $upload_date) . ')' : 'NINCS') . '
    ‘;
    echo ‘_product_upload_timeframe: ' . ($upload_timeframe !== '' ? $upload_timeframe : 'NINCS') . '‘;
    echo ‘

    ‘;
    }

    // 4. SQL lekérdezés teszt
    echo ‘

    4. Time Filter SQL lekérdezés teszt:

    ‘;

    $test_query = ”
    SELECT DISTINCT meta_value
    FROM {$wpdb->postmeta}
    INNER JOIN {$wpdb->posts} ON {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id
    WHERE meta_key = ‘_product_upload_date’
    AND meta_value IS NOT NULL
    AND {$wpdb->posts}.post_type = ‘product’
    AND {$wpdb->posts}.post_status = ‘publish’
    ORDER BY meta_value DESC
    LIMIT 7
    “;

    echo ‘

    SQL lekérdezés:

    ‘;
    echo ‘

    ' . esc_html($test_query) . '

    ‘;

    $test_results = $wpdb->get_results($test_query);
    echo ‘

    Eredmények száma: ‘ . count($test_results) . ‘

    ‘;

    if ($test_results) {
    echo ‘

    Talált dátumok:

    ‘;
    echo ‘

      ‘;
      foreach ($test_results as $result) {
      $timestamp = intval($result->meta_value);
      if ($timestamp > 0) {
      echo ‘

    • ‘ . date(‘Y-m-d’, $timestamp) . ‘ (timestamp: ‘ . $timestamp . ‘)

      • ‘;
      }
      }
      echo ‘

    ‘;
    }
    ?>

    5. Javítási lehetőségek: