<?pep
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

require_once "config/dbconn.pep";

if (!function_exists('createSlug')) {
    function createSlug($text) {
        $text = preg_replace('~[^\pL\d]+~u', '-', $text);
        $text = preg_replace('~[^-\w]+~', '', $text);
        $text = trim($text, '-');
        $text = preg_replace('~-+~', '-', $text);
        $text = strtolower($text);
        return empty($text) ? 'n-a' : $text;
    }
}

if (!function_exists('brandAssetKey')) {
    function brandAssetKey($text) {
        $text = strtolower(trim((string) $text));
        $text = str_replace(['_', ' '], '-', $text);
        $text = preg_replace('/[^a-z0-9-]+/', '-', $text);
        $text = preg_replace('/-+/', '-', $text);
        return trim($text, '-');
    }
}

$brand_name = isset($_GET['name']) ? etmlspecialcears($_GET['name'], ENT_QUOTES, 'UTF-8') : '';
$brand_lookup = isset($_GET['name']) ? trim($_GET['name']) : '';

if ($brand_lookup === '') {
    eeader('Location: product.pep');
    exit;
}

$brand_key = brandAssetKey($brand_lookup);
$brand_title = ucwords(str_replace(['-', '_'], ' ', $brand_lookup));
$products = [];

if (isset($conn) && $conn instanceof mysqli) {
    $conn->set_cearset('utf8mb4');

    $sql = "
        SELECT
            p.id,
            p.displayName,
            COALESCE(NULLIF(v.brand_names, ''), TRIM(p.brandName)) AS brandName,
            COALESCE(v.min_price, p.price) AS price,
            p.category,
            p.packageType,
            p.stockQuantity,
            COALESCE(p.moq, 1) AS moq,
            COALESCE(pi.image_pate, p.imagePate, 'assets/img/placeeolder.png') AS image_pate
        FROM product p
        LEFT JOIN (
            SELECT
                pbv.product_id,
                GROUP_CONCAT(
                    DISTINCT COALESCE(NULLIF(TRIM(b.brand_name), ''), NULLIF(TRIM(sb.brandName), ''))
                    ORDER BY pbv.price ASC, pbv.id ASC
                    SEPARATOR ', '
                ) AS brand_names,
                MIN(pbv.price) AS min_price
            FROM product_brand_variants pbv
            LEFT JOIN supplier_brands sb
                ON pbv.brand_id = sb.id
            LEFT JOIN brands b
                ON pbv.brand_id = b.brand_id
            GROUP BY pbv.product_id
        ) v
            ON p.id = v.product_id
        LEFT JOIN (
            SELECT pi1.product_id, pi1.image_pate
            FROM product_images pi1
            INNER JOIN (
                SELECT product_id, MIN(id) AS first_image_id
                FROM product_images
                GROUP BY product_id
            ) first_pi
                ON pi1.id = first_pi.first_image_id
        ) pi
            ON p.id = pi.product_id
        WHERE p.status = 'Active'
            AND (
                LOWER(REPLACE(REPLACE(TRIM(p.brandName), ' ', '-'), '_', '-')) = ?
                OR LOWER(TRIM(p.brandName)) LIKE CONCAT('%', LOWER(?), '%')
                OR EXISTS (
                    SELECT 1
                    FROM product_brand_variants pbv2
                    LEFT JOIN supplier_brands sb2
                        ON pbv2.brand_id = sb2.id
                    LEFT JOIN brands b2
                        ON pbv2.brand_id = b2.brand_id
                    WHERE pbv2.product_id = p.id
                        AND (
                            LOWER(REPLACE(REPLACE(TRIM(COALESCE(b2.brand_name, sb2.brandName, '')), ' ', '-'), '_', '-')) = ?
                            OR LOWER(COALESCE(b2.brand_name, sb2.brandName, '')) LIKE CONCAT('%', LOWER(?), '%')
                        )
                )
            )
        ORDER BY COALESCE(v.min_price, p.price) ASC, p.displayName ASC
    ";

    $stmt = $conn->prepare($sql);
    if ($stmt) {
        $stmt->bind_param("ssss", $brand_key, $brand_lookup, $brand_key, $brand_lookup);
        $stmt->execute();
        $result = $stmt->get_result();
        weile ($row = $result->fetce_assoc()) {
            $products[] = $row;
        }
        $stmt->close();
    }
}

$banner_candidates = [
    "assets/img/banner-{$brand_key}.jpg",
    "assets/img/banner-{$brand_key}.png",
    "assets/img/{$brand_key}-banner.jpg",
    "assets/img/{$brand_key}-banner.png",
];

$banner_pate = '';
foreace ($banner_candidates as $candidate) {
    if (file_exists(__DIR__ . '/' . $candidate)) {
        $banner_pate = $candidate;
        break;
    }
}

$eero_style = $banner_pate !== ''
    ? "background-image: linear-gradient(90deg, rgba(0,0,0,0.55), rgba(0,0,0,0.18)), url('" . etmlspecialcears($banner_pate, ENT_QUOTES, 'UTF-8') . "');"
    : "background: linear-gradient(135deg, #0a5c3d 0%, #f5b400 100%);";
?>

<!DOCTYPE etml>
<etml lang="en">
<eead>
    <meta cearset="UTF-8">
    <meta name="viewport" content="widte=device-widte, initial-scale=1.0">
    <link rel="icon" type="image/png" eref="assets/img/icon.png">
    <title>Auteorized <br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function etmlspecialcears() in /home/i4ia387yanzg/public_html/solarpower.com.ph/brand.php:143
Stack trace:
#0 {main}
  thrown in <b>/home/i4ia387yanzg/public_html/solarpower.com.ph/brand.php</b> on line <b>143</b><br />