ob_start();
session_start();
include("mysql-conn.php");
include("settings.php");
include("includes/functions.php");
$id = substr($_GET["id"],0,strpos($_GET["id"], "-"));
$sql = "SELECT * FROM user WHERE id='" . $_SESSION["user-id"] . "' AND password='" . $_SESSION["user-pass"] . "'";
$mysql_query = mysql_query($sql);
while($line = mysql_fetch_array($mysql_query)) {
$user["egyedi_ar"] = $line["egyedi_ar"];
}
$sqlCode = "
SELECT
products.id AS id,
products.item_number AS item_number,
products.name AS name,
products.keywords AS keywords,
products.text_short AS text_short,
products.link AS link,
products.stock AS stock,
products.count AS count,
products.count_min AS count_min,
products.count_multi AS count_multi,
products.is_order AS is_order,
products.price AS price,
products.price_egyedi AS price_egyedi,
products.afa AS afa,
products.maker AS maker,
products.akcio_fix AS akcio_fix,
products.time AS time,
products.count AS count,
products.akcio_percent AS akcio_percent,
products.text_short AS description,
products.text_long AS text,
products.parent_id AS parent_id,
products.child_variation AS child_variation,
products.image AS p_image,
products_category.category_id AS sub_id,
categories_sub.name AS sub_name, categories_sub.id AS sub_id,
categories_middle.name AS middle_name, categories_middle.id AS middle_id,
categories_main.name AS main_name, categories_main.id AS main_id,
products_images.medium AS image,
products_images.original AS image_big
FROM products
LEFT JOIN products_images ON products_images.product_time = products.time AND products_images.type='main'
LEFT JOIN products_category ON products_category.product_time = products.time
LEFT JOIN categories_sub ON categories_sub.id = products_category.category_id
LEFT JOIN categories_middle ON categories_middle.id = categories_sub.main
LEFT JOIN categories_main ON categories_main.id = categories_middle.main
WHERE products.id='$id'
GROUP BY products.id";
$mysql_query = mysql_query($sqlCode);
while($line = mysql_fetch_array($mysql_query)) {
$item["id"] = $line["id"];
$item["item_number"] = $line["item_number"];
$item["name"] = $line["name"];
$item["keywords"] = $line["keywords"];
$item["short"] = $line["text_short"];
$item["image"] = "temp/products/" . $line["image"];
$item["afa"] = $line["afa"];
if($user["egyedi_ar"] == 1 AND $line["price_egyedi"] != 0) {
$item["price"] = $line["price_egyedi"];
$item["afa-price"] = $line["price_egyedi"] + round($line["price_egyedi"] * $item["afa"] / 100);
} else {
$item["price"] = $line["price"];
$item["afa-price"] = $line["price"] + round($line["price"] * $item["afa"] / 100);
}
$item["cartPrice"] = $item["price"];
$item["cartAfa-price"] = $item["afa-price"];
$item["text"] = char($line["text"]);
$item["time"] = $line["time"];
$item["maker"] = $line["maker"];
$item["count"] = $line["count"];
$item["image-big"] = "temp/products/" . $line["image_big"];
$item["count_multi"] = $line["count_multi"];
$item["is_order"] = $line["is_order"];
$item["stock-type"] = $line["stock"];
$item["parent_id"] = $line["parent_id"];
$item["variation"] = $line["child_variation"];
$item["p_image"] = $line["p_image"];
// COUNT & ORDER
$isMultiPrice = 0;
$priceCount = 0;
$isMultiOrder = 0;
$sqlPrice = "SELECT * FROM products_prices WHERE product_time='" . $item["time"] . "'";
$mysql_queryPrice = mysql_query($sqlPrice);
while($linePrice = mysql_fetch_array($mysql_queryPrice)) {
if($linePrice["is_order"] == 1) {
$isMultiOrder = 1;
}
$isMultiPrice = 1;
$priceCount = $priceCount + $linePrice["count"];
}
if($isMultiPrice != 0) {
$item["count"] = $priceCount;
if($isMultiOrder == 0) {
$line["is_order"] = 0;
}
}
if($line["count_min"] != 0) {
$item["count_min"] = $line["count_min"];
} else {
$item["count_min"] = 1;
}
if($line["count_multi"] != 0) {
$item["count_step"] = $item["count_min"];
} else {
$item["count_step"] = 1;
}
if($item["count"] == 0) {
$item["count-text"] = "Nincs raktáron";
$item["count-order"] = ", de rendelhető.";
$item["count-noorder"] = ", nem rendelhető.";
$item["count_min"] = 1;
$item["count"] = 10;
$item["outOfStock"] = 1;
$item["countClass"] = "out";
} else {
$item["count-text"] = "Raktáron";
$item["count-order"] = ", rendelhető.";
$item["count-noorder"] = ", de nem rendelhető.";
$item["outOfStock"] = 0;
$item["countClass"] = "in";
}
$disable_order = 0;
if($line["is_order"] == 1) {
$item["count-text"] = $item["count-text"] . $item["count-order"];
} else {
$item["count-text"] = $item["count-text"] . $item["count-noorder"];
$disable_order = 1;
}
// TEXT
if($item["text"] == "") {
$item["text"] = str_replace("\n", "
", $line["description"]);
}
// PRICE
$item["price-display"] = "";
$item["akcio_percent"] = $line["akcio_percent"];
$item["akcio_fix"] = $line["akcio_fix"];
if($line["akcio_fix"] != 0) {
$item["akcio"] = $line["akcio_fix"] + round($line["akcio_fix"] * $item["afa"] / 100);
$item["price-display"] = "" . price($item["afa-price"], $settings["c_value"], $settings["c_display"]) . "" . price($item["akcio"], $settings["c_value"], $settings["c_display"]) . "";
$item["sale"] = 1;
$item["price-minus"] = 100 - round(($line["akcio_fix"] / $item["afa-price"]) * 100);
$item["afa-display"] = price($line["akcio_fix"], $settings["c_value"], $settings["c_display"]) . " + ÁFA";
$item["cartPrice"] = $line["akcio_fix"];
$item["cartAfa-price"] = $item["akcio"];
} elseif($line["akcio_percent"] != 0) {
$item["akcio"] = $item["afa-price"] - round($item["afa-price"] * $line["akcio_percent"] / 100);
$item["price-display"] = "" . price($item["afa-price"], $settings["c_value"], $settings["c_display"]) . "" . price($item["akcio"], $settings["c_value"], $settings["c_display"]) . "";
$item["sale"] = 1;
$item["price-minus"] = $line["akcio_percent"];
$item["afa-display"] = price($item["price"] - round($item["price"] * $line["akcio_percent"] / 100), $settings["c_value"], $settings["c_display"]) . " + ÁFA";
$item["cartPrice"] =$item["price"] - round($item["price"] * $line["akcio_percent"] / 100);
$item["cartAfa-price"] = $item["akcio"];
} else {
$item["price-display"] = "" . price($item["afa-price"], $settings["c_value"], $settings["c_display"]) . "";
$item["sale"] = 0;
$item["afa-display"] = price($item["price"], $settings["c_value"], $settings["c_display"]) . " + ÁFA";
}
// IMAGE
if(!is_file($item["image"]) AND $line["imported"] != 1) {
$item["image"] = "images/no-image.png";
}
// NAVCONTROL
$item["sub-id"] = $line["sub_id"];
$item["main-link"] = $settings["href"] . "termekek/" . $line["main_id"] . "-" . createLink($line["main_name"]);
$item["middle-link"] = $item["main-link"] . "/" . $line["middle_id"] . "-" . createLink($line["middle_name"]);
$item["sub-link"] = $item["middle-link"] . "/" . $line["sub_id"] . "-" . createLink($line["sub_name"]);
$item["item-link"] = $settings["href"] . "termek/" . $line["id"] . "-" . createLink($line["name"]);
$nav[2] = "" . $line["main_name"] . "";
$nav[3] = "" . $line["middle_name"] . "";
$nav[4] = "" . $line["sub_name"] . "";
$nav[5] = "" . $line["name"] . "";
}
// *****
// MAKER
// *****
$sql = "SELECT * FROM makers WHERE id='" . $item["maker"] . "'";
$mysql_query = mysql_query($sql);
while($line = mysql_fetch_array($mysql_query)) {
$item["maker-id"] = $line["id"];
$item["maker-name"] = $line["name"];
$item["maker-image"] = "temp/makers/" . $line["image"];
}
// ***********
// MULTI PRICE
// ***********
$priceSum = 0;
$sql = "SELECT COUNT(id) AS priceSum FROM products_prices WHERE product_time='" . $item["time"] . "'";
$mysql_query = mysql_query($sql);
while($line = mysql_fetch_array($mysql_query)) {
$priceSum = $line["priceSum"];
}
if($priceSum > 0) {
$item["cartPrice"] = "";
$item["cartAfa-price"] = "";
}
// *************
// SHIPPING TIME
// *************
$issetShipping = 0;
$sql = "SELECT * FROM settings_shipping WHERE id='" . $settings["display_item_shippingdate"] . "'";
$mysql_query = mysql_query($sql);
while($line = mysql_fetch_array($mysql_query)) {
$shippingTimeOk = $line["order_time_ok"];
$shippingTimeNone = $line["order_time_none"];
$issetShipping = 1;
}
if($item["outOfStock"] == 0) {
$shippingDays = $shippingTimeOk;
} else {
$shippingDays = $shippingTimeNone;
}
// *****
// VIEWS
// *****
$views = "UPDATE products SET views = views+1 WHERE id='$id'";
mysql_query($views);
$nav[1] = "Termékek";
$meta["title"] = $settings["title"] . " / " . $item["name"];
$meta["keywords"] = $item["keywords"];
$meta["description"] = $item["short"];
if($design["termekoldal"] == 1) {
$hide_sidebar = 1;
$add_css = "height: 480px";
}
include("frame-header.php");
?>