<?php
/**
 * Помощна страница за извличане на информация за продукти по ID или референция.
 * Поставете файла в корена на PrestaShop магазина (до index.php) и отворете /fbads.php
 *
 * Тествано с PrestaShop 1.6/1.7/8.*
 * НЕ е модул. Не променя база данни.
 */

// Зареждане на средата на PrestaShop
@ini_set('display_errors', '1');
@error_reporting(E_ALL);

if (!file_exists(__DIR__ . '/config/config.inc.php')) {
    die('Не е открит config/config.inc.php. Уверете се, че файлът е в корена на магазина.');
}

require_once __DIR__ . '/config/config.inc.php';
require_once __DIR__ . '/init.php';

$context  = Context::getContext();
$link     = $context->link;
$id_lang  = (int)Configuration::get('PS_LANG_DEFAULT');
$currency = $context->currency ?: new Currency((int)Configuration::get('PS_CURRENCY_DEFAULT'));

// ------------------- Помощни функции -------------------
function sanitize_filename($str) {
    $str = html_entity_decode($str, ENT_QUOTES, 'UTF-8');
    $str = preg_replace('/[\r\n]+/', ' ', $str);
    $str = preg_replace('/[^\pL\pN\s._-]+/u', '', $str);
    $str = trim(preg_replace('/[\s]+/u', ' ', $str));
    $str = str_replace(' ', '_', $str);
    return $str === '' ? 'product' : $str;
}

function price_fmt($amount, $currency) {
    if (class_exists('PrestaShop\\PrestaShop\\Adapter\\Product\\PriceFormatter')) {
        $pf = new PrestaShop\PrestaShop\Adapter\Product\PriceFormatter();
        return $pf->format($amount, (int)$currency->id);
    }
    return Tools::displayPrice($amount, $currency);
}

function find_product_id_by_reference($ref) {
    $ref = trim($ref);
    if ($ref === '') return null;
    $sql = 'SELECT id_product FROM '._DB_PREFIX_.'product WHERE reference = \'' . pSQL($ref) . '\'';
    $row = Db::getInstance()->getRow($sql);
    if ($row && !empty($row['id_product'])) return (int)$row['id_product'];
    // опит и в комбинациите
    $sql2 = 'SELECT pa.id_product FROM '._DB_PREFIX_.'product_attribute pa WHERE pa.reference = \'' . pSQL($ref) . '\'';
    $row2 = Db::getInstance()->getRow($sql2);
    if ($row2 && !empty($row2['id_product'])) return (int)$row2['id_product'];
    return null;
}

function get_cover_image_id($id_product) {
    $cover = Image::getCover((int)$id_product);
    return ($cover && !empty($cover['id_image'])) ? (int)$cover['id_image'] : null;
}

function image_url($link, $product, $id_image) {
    $rewrite = isset($product->link_rewrite) && is_array($product->link_rewrite)
        ? (string)reset($product->link_rewrite)
        : (isset($product->link_rewrite) ? (string)$product->link_rewrite : '');

    // Предпочитан тип изображение
    $type = null; $available = array();
    if (class_exists('ImageType') && method_exists('ImageType','getImagesTypes')) {
        $types = ImageType::getImagesTypes('products');
        foreach ($types as $t) $available[] = $t['name'];
        foreach (array('large_default','large','scene_default','home_default') as $p) {
            if (in_array($p, $available)) { $type = $p; break; }
        }
    }
    return $link->getImageLink($rewrite, $id_image, $type);
}

function image_disk_path($id_image) {
    $base = _PS_IMG_DIR_.'p/'.Image::getImgFolderStatic($id_image).$id_image;
    foreach (array('.jpg','.jpeg','.webp','.png') as $ext) {
        $path = $base.$ext; if (is_file($path)) return $path;
    }
    return $base.'.jpg';
}

function make_short_product_link(Link $link, Product $product, $id_lang) {
    $full = $link->getProductLink(
        $product->id,
        is_array($product->link_rewrite) ? reset($product->link_rewrite) : $product->link_rewrite,
        null, null, (int)$id_lang, null, 0, false
    );
    $rewrite = is_array($product->link_rewrite) ? reset($product->link_rewrite) : $product->link_rewrite;
    if ($rewrite) {
        $full = preg_replace('#-'.preg_quote($rewrite, '#').'\\.html$#u', '-.html', $full);
    } else if (substr($full, -5) !== '.html') {
        $full .= '-.html';
    }
    return $full;
}

// ------------------- Download на снимка -------------------
// ВАЖНО: не изискваме pid; стига ни iid и fname. Това позволява линкът да работи.
if (Tools::getIsset('download') && Tools::getIsset('iid') && Tools::getIsset('fname')) {
    $id_image = (int)Tools::getValue('iid');
    $fname    = sanitize_filename(Tools::getValue('fname'));
    if (!preg_match('/\.(jpe?g|png|webp)$/i', $fname)) $fname .= '.jpg';

    $path = image_disk_path($id_image);
    if (!is_file($path)) {
        header('HTTP/1.1 404 Not Found');
        header('Content-Type: text/plain; charset=utf-8');
        echo "Снимката не е намерена на диска.";
        exit;
    }
    $ext  = strtolower(pathinfo($path, PATHINFO_EXTENSION));
    $mime = ($ext==='png') ? 'image/png' : (($ext==='webp') ? 'image/webp' : 'image/jpeg');

    // Заглавни части за изтегляне
    header('Content-Type: '.$mime);
    header('Content-Disposition: attachment; filename="'.$fname.'"');
    header('Content-Length: '.filesize($path));
    header('Cache-Control: private, max-age=0, must-revalidate');
    header('Pragma: public');

    readfile($path);
    exit;
}

// ------------------- Входни данни -------------------
$input = isset($_POST['refs']) ? trim($_POST['refs']) : '';
$mode  = isset($_POST['mode']) && $_POST['mode']==='id' ? 'id' : 'ref'; // 'id' или 'ref'
$lines = array();
if ($input !== '') {
    foreach (preg_split('/\r?\n/', $input) as $line) {
        $line = trim($line);
        if ($line !== '') $lines[] = $line;
    }
}

// ------------------- Сглобяване на резултати -------------------
$results = array();
foreach ($lines as $token) {
    // 1) Намери продукт ID според режима
    if ($mode === 'id') {
        $pid = ctype_digit($token) ? (int)$token : null;
    } else {
        $pid = find_product_id_by_reference($token);
    }

    if (!$pid) {
        $results[] = array('token'=>$token, 'error'=>'Не е намерен продукт.');
    } else {
        // 2) Зареди продукта
        $product = new Product($pid, true, $id_lang);
        if (!Validate::isLoadedObject($product)) {
            $results[] = array('token'=>$token, 'error'=>'Продуктът не може да бъде зареден.');
        } else {
            // 3) Цени
            $price_with    = Product::getPriceStatic($product->id, true);
            $price_without = Product::getPriceStatic($product->id, true, null, 6, null, false, false);
            $reduction_amount  = max(0, $price_without - $price_with);
            $reduction_percent = ($price_without > 0) ? round(($reduction_amount / $price_without) * 100) : 0;

            // 4) Снимка/линк
            $id_image   = get_cover_image_id($product->id);
            $img_url    = $id_image ? image_url($link, $product, $id_image) : null;
            $short_link = make_short_product_link($link, $product, $id_lang);

            // 5) Име, ref, име на файл
            $date  = date('dmY');
            $pname = is_array($product->name) ? reset($product->name) : $product->name;
            $ref   = is_array($product->reference) ? reset($product->reference) : $product->reference;

            $fname_id = ($mode === 'ref' && $token ? $token : ($ref ?: $product->id));
            $fname    = sanitize_filename($fname_id.'_'.$date.'_'.$pname).'.jpg';

            $price_clip = 'Price was: '.price_fmt($price_without,$currency)
                        .' NOW IS: '.price_fmt($price_with,$currency)
                        .' - You Save: '.$reduction_percent.'%';

            $results[] = array(
                'token' => $token,
                'id'    => $product->id,
                'name'  => $pname,
                'ref'   => $ref,
                'img_url' => $img_url,
                'id_image'=> $id_image,
                'download_fname' => $fname,
                'short_link'=> $short_link,
                'price_with' => $price_with,
                'price_without' => $price_without,
                'reduction_amount' => $reduction_amount,
                'reduction_percent'=> $reduction_percent,
                'price_clip' => $price_clip,
            );
        }
    }
}

// ------------------- HTML -------------------
?>
<!doctype html>
<html lang="bg">
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>Продукти по ID/Референция • PrestaShop</title>
  <style>
    body { font-family: -apple-system, BlinkMacSystemFont, Segoe UI, Roboto, Arial, sans-serif; margin: 24px; background: #f6f7fb; }
    h1 { font-size: 20px; margin-bottom: 12px; }
    .card { background: #fff; border: 1px solid #e5e7eb; border-radius: 14px; padding: 16px; margin-bottom: 16px; box-shadow: 0 2px 6px rgba(0,0,0,.04); }
    textarea { width: 100%; min-height: 140px; font-family: ui-monospace, SFMono-Regular, Menlo, Monaco, Consolas, "Liberation Mono", monospace; padding: 12px; border-radius: 10px; border: 1px solid #d1d5db; }
    .btn { display: inline-block; padding: 8px 12px; border-radius: 10px; border: 1px solid #111827; text-decoration: none; background: #111827; color: #fff; font-weight: 600; cursor: pointer; }
    .btn.secondary { background: #fff; color: #111827; border-color: #d1d5db; }
    .btn.slim { padding: 6px 10px; font-size: 12px; margin-right: 6px; }
    .row { display: grid; grid-template-columns: 160px 1fr; gap: 16px; align-items: start; }
    .imgbox { background: #fafafa; border: 1px solid #eee; border-radius: 12px; padding: 8px; display:flex; align-items:center; justify-content:center; }
    img { max-width: 150px; height: auto; border-radius: 8px; }
    .meta { font-size: 14px; }
    .meta a { color: #0b67ff; text-decoration: none; }
    .price { font-size: 16px; font-weight: 700; }
    .muted { color: #6b7280; }
    .strike { color: #6b7280; text-decoration: line-through; margin-left: 8px; font-weight: 400; }
    .badge { display:inline-block; padding: 2px 8px; background:#ecfdf5; color:#065f46; border:1px solid #a7f3d0; border-radius: 999px; font-size:12px; margin-left:8px; }
    .err { color:#b91c1c; font-weight:600; }
    .download { margin-top:8px; }
    .top { display:flex; align-items:center; justify-content:space-between; gap:12px; }
    .inline { display:flex; gap:10px; align-items:center; margin:8px 0; flex-wrap:wrap; }
    label.radio { display:flex; align-items:center; gap:6px; font-size:13px; }
  </style>
</head>
<body>
  <div class="card">
    <div class="top">
      <h1>Извличане на продукти по ID или референция</h1>
      <div class="muted">Всеки идентификатор на нов ред</div>
    </div>
    <form method="post">
      <div class="inline">
        <label class="radio"><input type="radio" name="mode" value="ref" <?php echo ($mode==='ref')?'checked':''; ?>> Референтни номера</label>
        <label class="radio"><input type="radio" name="mode" value="id"  <?php echo ($mode==='id')?'checked':''; ?>> ID на продукти</label>
      </div>
      <textarea name="refs" placeholder="<?php echo ($mode==='ref')? 'REF001\nREF002' : '12\n345\n789'; ?>"><?php echo htmlspecialchars($input, ENT_QUOTES, 'UTF-8'); ?></textarea>
      <div style="margin-top:12px">
        <button class="btn" type="submit">Покажи</button>
        <a class="btn secondary" href="<?php echo htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8'); ?>">Изчисти</a>
      </div>
    </form>
  </div>

  <?php foreach ($results as $r): ?>
    <div class="card">
      <div class="row">
        <div class="imgbox">
          <?php if (!empty($r['img_url'])): ?>
            <img src="<?php echo htmlspecialchars($r['img_url'], ENT_QUOTES, 'UTF-8'); ?>" alt="<?php echo htmlspecialchars($r['name'], ENT_QUOTES, 'UTF-8'); ?>">
          <?php else: ?>
            <div class="muted">Няма снимка</div>
          <?php endif; ?>
        </div>
        <div>
          <div class="meta">
            <div><strong>Вход:</strong> <?php echo htmlspecialchars($r['token'], ENT_QUOTES, 'UTF-8'); ?></div>
            <?php if (!empty($r['ref'])): ?>
              <div><strong>Референция:</strong> <?php echo htmlspecialchars($r['ref'], ENT_QUOTES, 'UTF-8'); ?></div>
            <?php endif; ?>

            <?php if (!empty($r['error'])): ?>
              <div class="err"><?php echo htmlspecialchars($r['error'], ENT_QUOTES, 'UTF-8'); ?></div>
            <?php else: ?>

              <div class="inline">
                <strong>Име:</strong>
                <button class="btn slim" data-copy="<?php echo htmlspecialchars($r['name'], ENT_QUOTES, 'UTF-8'); ?>">Copy</button>
                <span><?php echo htmlspecialchars($r['name'], ENT_QUOTES, 'UTF-8'); ?></span>
              </div>

              <div class="inline">
                <strong>Линк:</strong>
                <button class="btn slim" data-copy="<?php echo htmlspecialchars($r['short_link'], ENT_QUOTES, 'UTF-8'); ?>">Copy</button>
                <a href="<?php echo htmlspecialchars($r['short_link'], ENT_QUOTES, 'UTF-8'); ?>" target="_blank" rel="noopener"><?php echo htmlspecialchars($r['short_link'], ENT_QUOTES, 'UTF-8'); ?></a>
              </div>

              <div class="inline">
                <strong>Цена:</strong>
                <button class="btn slim" data-copy="<?php echo htmlspecialchars($r['price_clip'], ENT_QUOTES, 'UTF-8'); ?>">Copy</button>
                <span class="price"><?php echo price_fmt($r['price_with'], $currency); ?></span>
                <?php if ($r['reduction_amount'] > 0): ?>
                  <span class="strike"><?php echo price_fmt($r['price_without'], $currency); ?></span>
                  <span class="badge">-<?php echo (int)$r['reduction_percent']; ?>%</span>
                <?php endif; ?>
              </div>

              <?php if ($r['img_url'] && $r['id_image']): ?>
                <div class="download">
                  <a class="btn"
                     href="<?php echo htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8'); ?>?download=1&amp;iid=<?php echo (int)$r['id_image']; ?>&amp;fname=<?php echo rawurlencode($r['download_fname']); ?>"
                     target="_blank" rel="noopener"
                     title="Изтегли оригиналната снимка">Изтегли</a>
                  <span class="muted" style="margin-left:8px">Ще се запише като: <?php echo htmlspecialchars($r['download_fname'], ENT_QUOTES, 'UTF-8'); ?></span>
                </div>
              <?php endif; ?>

            <?php endif; ?>
          </div>
        </div>
      </div>
    </div>
  <?php endforeach; ?>

  <script>
    // Copy-to-clipboard за всички бутони с data-copy
    function copyText(txt) {
      if (navigator.clipboard && window.isSecureContext) {
        return navigator.clipboard.writeText(txt);
      } else {
        const ta = document.createElement('textarea');
        ta.value = txt; document.body.appendChild(ta); ta.select();
        try { document.execCommand('copy'); } finally { document.body.removeChild(ta); }
        return Promise.resolve();
      }
    }
    document.addEventListener('click', function(e){
      const btn = e.target.closest('button[data-copy]');
      if (!btn) return; e.preventDefault();
      const txt = btn.getAttribute('data-copy');
      const old = btn.textContent;
      copyText(txt).then(function(){ btn.textContent = 'Copied!'; setTimeout(()=>btn.textContent=old, 1200); });
    });
  </script>

  <footer class="muted" style="margin-top:24px; font-size:12px;">
    Съвет: можете да експортирате лесно името, цената и линка чрез копиране на бутона пред всеки елемент.
  </footer>
</body>
</html>