<?
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", "<br/>", $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"] = "<span class='a'>" . price($item["afa-price"], $settings["c_value"], $settings["c_display"]) . "</span><span class='an'>" . price($item["akcio"], $settings["c_value"], $settings["c_display"]) . "</span>";
			$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"] = "<span class='a'>" . price($item["afa-price"], $settings["c_value"], $settings["c_display"]) . "</span><span class='an'>" . price($item["akcio"], $settings["c_value"], $settings["c_display"]) . "</span>";
			$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"] = "<span class='n'>" . price($item["afa-price"], $settings["c_value"], $settings["c_display"]) . "</span>";
			$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] = "<a href='" . $item["main-link"] . "'>" . $line["main_name"] . "</a>";
	$nav[3] = "<a href='" . $item["middle-link"] . "'>" . $line["middle_name"] . "</a>";
	$nav[4] = "<a href='" . $item["sub-link"] . "'>" . $line["sub_name"] . "</a>";
	$nav[5] = "<a href='" . $item["item-link"] . "'>" . $line["name"] . "</a>";

}

// *****
// 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] = "<a href='" . $settings["href"] . "termekek'>Termékek</a>";

$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");
?>

<div class="content-head"><h1></h1></div>

<div class="content-container" id="item-content-container">

	<table class="item-table">

		<tr>
		
			<td class="item-table-img" style="">
			
				<div id="zoom" data-zoom-image="" class="item-image" style="background-image: url('');"></div>

				<script type="text/javascript">

					$("#zoom").click(function(){
					
						$("#imageGallery a:nth-child(1)").trigger("click");

					});

					$("#zoom").elevateZoom({
						easing: true,
						zoomType: "lens",
						lensShape: "round",
						lensColour: "white"
				   }); 
				</script>
				
				<span id="imageGallery">

					<?
					$sql = "SELECT * FROM products_images WHERE product_time='" . $item["time"] . "' ORDER BY type";
					$mysql_query = mysql_query($sql);
					while($line = mysql_fetch_array($mysql_query)) {					
					$image["big"]   = "temp/products/" . $line["original"];
					$image["small"] = "temp/products/" . $line["small"];
					?>


						<a class="fancybox-thumbs" data-fancybox-group="thumb" href="" title=""><img src="" alt="" /></a>

					<?
					}
					?>

				</span>

			</td>

			<td class="item-table-info">
				
				<table class="info-table">

					<tr>
						<td>Termék ára</td>
						<td id="priceCell">
							
							<div id="item-price">
							
								<div class="item-price">
																	</div>
								
								<?
								if($item["afa"] != 0) {
								?>
								<div class="item-price-afa"></div>
								<?
								}
								?>

							</div>

						</td>
					</tr>
					<?
					if($settings["display_product_id"] == "id") {
					?>
					<tr>
						<td>Azonosító</td>
						<td></td>
					</tr>
					<?
					} else {
					?>
					<tr>
						<td>Cikkszám</td>
						<td></td>
					</tr>
					<?

					}
					?>

					<tr>
						<td>Elérhetőség</td>
						<td class="stock-" id="product_avaliable"></td>
					</tr>
					
					<?
					if((!ctype_xdigit(substr($item["variation"], 1)) || substr($item["variation"], 0, 1) != "#")  AND $item["variation"] != "") {
					
						?>
						<tr>
							<td>Változat</td>
							<td></td>
						</tr>
						<?
						$selectVariationLabel = "A termék a következő változatokban rendelhető:";
						
					} else {
						$selectVariationLabel = "A termék a következő színekben rendelhető:";
					}

					if($item["maker-name"] != "") {
					?>
					
						<tr>
							<td>Gyártó</td>
							<td>
								
								<?
								if(is_file($item["maker-image"])) {
								?>
								
								<a class="mfr-image" href="gyarto/