<?php
include "../vendor/autoload.php";
include "../connect.php";

if (isset($_GET['bovebben']) && $_GET['bovebben'] != "") {
  $bovebben = $_GET['bovebben'];

  $linkvizsgalat = (int)$bovebben;

  if ($linkvizsgalat > 0) {
    $lekerdezes = "SELECT *
                      FROM posts
                      WHERE posts.id='$bovebben'
                      AND posts.status='APPROVED'";
  } else {
    $lekerdezes = "SELECT *
                      FROM posts
                      WHERE posts.slug='$bovebben'
                      AND posts.status='APPROVED'";
  }

  $talalat = $conn->query($lekerdezes);
  $talalatok_szama = $talalat->num_rows;
  $sor = $talalat->fetch_assoc();
  $valtozo = $mp . '/api/image/' . stripslashes($sor['imageMediaId']) . '?w=1200&h=630';
  $cimvaltozo = stripslashes($sor['title']);
?>
  <?php require_once('includes/header.php'); ?>
  <meta property="og:image" content="https://gyermekut.hu<?php echo $valtozo; ?>" />
  <meta property="og:title" content="<?php echo $cimvaltozo; ?>" />
  <meta property="og:image:type" content="image/jpeg" />
  <meta property="og:image:width" content="1200" />
  <meta property="og:image:height" content="630" />
  </head>

  <body>
    <header>
      <?php require_once('includes/topsav.php'); ?>
      <?php require_once('includes/menu.php'); ?>
    </header>
    <div class="header_eltav"></div>
    <div class="container">

      <div class="fekete keparany">
      <?php

      for ($i = 0; $i < $talalatok_szama; $i++) {

        // Ellenőrizze, hogy a $sor['imageMediaId'] értékkel rendelkezik-e.
        //echo 'ImageMediaId: ' . $sor['imageMediaId'] . '<br>';

        // A kapcsolódó media objektum lekérdezése
        $media_lekerdezes = "SELECT * FROM media WHERE id='" . $sor['imageMediaId'] . "'";
        $media_talalat = $conn->query($media_lekerdezes)->fetch_object();
        
        $imageStyle = json_decode($sor['imageStyles']);
        $appendSize = '?w=1304&h=450"';
        if($imageStyle&&isset($imageStyle->wideCrop)&&isset($imageStyle->wideCrop->pixels)){
          $appendSize = '?cx='.$imageStyle->wideCrop->pixels->x
              .'&cy='.$imageStyle->wideCrop->pixels->y
              .'&cw='.$imageStyle->wideCrop->pixels->width
              .'&ch='.$imageStyle->wideCrop->pixels->height
              .'&w='.$imageStyle->wideCrop->pixels->width
              .'&h='.$imageStyle->wideCrop->pixels->height;
        }
        echo '<h2>';
        echo htmlspecialchars(stripslashes($sor['title']));
        echo '</h2>';
        if (isset($sor['imageMediaId'])) {
          echo '<img src="' .  $mp . '/api/image/' . stripslashes($sor['imageMediaId']) . $appendSize .'" alt="' . $media_talalat->description . '" title="' . stripslashes($sor['title']) . '">';
        }
        echo stripslashes($sor['content']);
      }
    } else {
      echo '<h1 class="text-danger">Nincs ilyen poszt!</h1>';
    }
      ?>
      <?php
      $conn->close();
      ?>
      </div>
    </div> <!-- container sorrendező vége -->
    <?php require_once('includes/footer.php'); ?>

    <!-- Cookies Consent - beleegyezés -->
    <?php
    if (!isset($_COOKIE['cookieConsent']) || $_COOKIE['cookieConsent'] != 1) {
      require_once('includes/cookies_consent.php');
    }
    ?>