<?
//-------------------------|
// engine by | Red Paprika |
// charset   | iso-8859-2  |
//-------------------------|

// ustawienia
$_bodyID="assortment";
$statPage="Asortyment / Produkt";

// moduly zewnetrzne
@include("modules/variables.php");
@include("modules/config.php");
@include("modules/connect.php");
@include("modules/functions.php");
@include("modules/smarty.php");
@include("modules/engine.php");

// statystyki
$statPage.=" / ".$_products[product][name];

// nazwa pliku
$_vFilename=makeLink("k".$_products[kind][id]."-",$_products[kind][name]);
$_vFilenameGroup=makeLink("g".$_products[group][id]."-",$_products[group][name]);
$_vFilenameKind=makeLink("k".$_products[kind][id]."-",$_products[kind][name]);

// produkty
$query="select * from ".$_base[prefix]."products where id='".$_products[product][id]."' && view='1'";
$result=mysql_query($query);
if($dane=mysql_fetch_array($result)){
	$dane[price]=priceFormat($dane[price]);
	$dane[promotionprice]=priceFormat($dane[promotionprice]);
	$dane[nprice]=priceFormat($dane[price]/1.22);
	$dane[npromotionprice]=priceFormat($dane[promotionprice]/1.22);
	$dane[vsite]=substr($dane[site],7);
	$dane[basketlink]=makeLink("b".$dane[id]."-",$dane[name]);
	$query1="select * from ".$_base[prefix]."products_photos where parent='$dane[id]' order by file limit 0,1";
	$result1=mysql_query($query1);
	if($dane1=mysql_fetch_array($result1))$dane[image][file]="p/s3/".$dane1[file];
	else $dane[image][file]="gfx/thumb400x300.jpg";
	$dane[image][size]=@getimagesize($dane[image][file]);
	// galeria
	$c=0;
	$query1="select * from ".$_base[prefix]."products_photos where parent='$dane[id]' order by file";
	$result1=mysql_query($query1);
	while($dane1=mysql_fetch_array($result1)){
		$dane[gallery][$c][s][file]="p/s2/".$dane1[file];
		$dane[gallery][$c][s][size]=@getimagesize($dane[gallery][$c][s][file]);
		$dane[gallery][$c][s][alt]=$dane1[alt];
		$dane[gallery][$c][b][file]="p/s3/".$dane1[file];
		$dane[gallery][$c][b][size]=@getimagesize($dane[gallery][$c][b][file]);
		$dane[gallery][$c][b][alt]=$dane1[alt];
		$c++;
	}
	//
	$products=$dane;
}

// opcje produktu
if($products[models]){
	$products[models]=eregi_replace(", ",",",$products[models]);
	$mods=explode(",",$products[models]);
	$products[models]=$mods;
}

// polecamy
if($products[others]){
	$products[others]=eregi_replace(", ",",",$products[others]);
	$o=explode(",",$products[others]);
	for($x=0;$x<count($o);$x++){
		$query="select * from ".$_base[prefix]."products where id='".$o[$x]."' && view='1'";
		$result=mysql_query($query);
		if($dane=mysql_fetch_array($result)){
			if($dane[producers])$ci[name]=$dane[producers]." ";
			$ci[name].=$dane[name];
			$ci[link]=makeLink("p".$dane[id]."-",$ci[name]);
			$others[]=$ci;
			unset($ci);
		}
	}
}

// tabele
$c=0;
$query="select * from ".$_base[prefix]."productstable where product='".$_products[product][id]."' order by position,id";
$result=mysql_query($query);
while($dane=mysql_fetch_array($result)){
	$query1="select * from ".$_base[prefix]."modeltable where id='$dane[parent]'";
	$result1=mysql_query($query1);
	if($dane1=mysql_fetch_array($result1)){
		$tables[$c][l]=explode("|",nl2br($dane1[rows]));
		$tables[$c][r]=explode("|",nl2br($dane[rows]));
		$tables[$c][t]=$dane1[name];
	}
	$c++;
}

// nazwa strony
$smarty->assign("_siteName",$_products[product][name]);

// smarty
$smarty->assign("_vFilename",$_vFilename);
$smarty->assign("_vFilenameGroup",$_vFilenameGroup);
$smarty->assign("_vFilenameKind",$_vFilenameKind);
$smarty->assign("products",$products);
$smarty->assign("tables",$tables);
$smarty->assign("others",$others);
$smarty->display("header.tpl");
$smarty->display("products.tpl");
@include("analyticsTracking.php");
$smarty->display("footer.tpl");

// statystyki
@include("cms/modules/stats.php");
?>