Revise paste Get products list by Id or Ref from prestasho...

<?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';
}

// ------------------- 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'); ?>

Изчисти

<?php echo htmlspecialchars($r['name'], ENT_QUOTES, 'UTF-8'); ?>

Няма снимка

Вход:

Референция:

Име:

Линк:

Цена: 0): ?> -%

Изтегли Ще се запише като: