var cat_id = "";
var prod_id = "";
var products = Array();
var price = Array();

var data = Array(

	Array(
		"Add-ins for Microsoft Outlook", Array(
			Array(
				"Actual contacts for Outlook ", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"Attachments Processor for Outlook", Array(
					Array (101, 150, 18),
					Array (151, 250, 17),
					Array (251, 350, 16),
					Array (351, 500, 15),
					Array (501, 750, 14),
					Array (751, 1000, 13),
					Array (1001, 1500, 12),
					Array (1501, 2000, 11.5),
					Array (2001, 3000, 11),
					Array (3001, 5000, 10.5),
					Array (5001, 10000, 10)
				)
			),
			Array(
				"Duplicates Remover for Outlook", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"E-mail Follow-Up", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"Mail Merge Toolkit", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"MAPILab NNTP for Outlook", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"MAPILab Toolbox", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"Print Tools for Outlook", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"Quick Templates for Outlook", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"Send Personally", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"Live Signatures for Outlook", Array(
					Array (101, 150, 12),
					Array (151, 250, 11),
					Array (251, 350, 10),
					Array (351, 500, 9),
					Array (501, 750, 8),
					Array (751, 1000, 7),
					Array (1001, 1500, 6.5),
					Array (1501, 2000, 6),
					Array (2001, 3000, 5.5),
					Array (3001, 5000, 5),
					Array (5001, 10000, 4)
				)
			),
			Array(
				"Duplicate Email Remover", Array(
					Array (101, 150, 7.5),
					Array (151, 250, 7),
					Array (251, 350, 6.5),
					Array (351, 500, 6),
					Array (501, 750, 5.5),
					Array (751, 1000, 5),
					Array (1001, 1500, 4.5),
					Array (1501, 2000, 4),
					Array (2001, 3000, 3.5),
					Array (3001, 5000, 3),
					Array (5001, 10000, 2.5)
				)
			),
			Array(
				"Add Contacts", Array(
					Array (101, 150, 7.5),
					Array (151, 250, 7),
					Array (251, 350, 6.5),
					Array (351, 500, 6),
					Array (501, 750, 5.5),
					Array (751, 1000, 5),
					Array (1001, 1500, 4.5),
					Array (1501, 2000, 4),
					Array (2001, 3000, 3.5),
					Array (3001, 5000, 3),
					Array (5001, 10000, 2.5)
				)
			),
			Array(
				"Easy Survey", Array(
					Array (10, 25, 35),
					Array (26, 50, 31.5),
					Array (51, 75, 28),
					Array (76, 100, 26.5),
					Array (101, 150, 24),
					Array (151, 250, 21.5),
					Array (251, 350, 20.5),
					Array (351, 500, 19.8),
					Array (501, 750, 18.5),
					Array (751, 1000, 17),
					Array (1001, 1500, 15),
					Array (1501, 2000, 12),
					Array (2001, 3000, 10),
					Array (3001, 5000, 7.5),
					Array (5001, 10000, 5)
				)
			),
			Array(
				"HTML Email Archiver", Array(
					Array (10, 25, 35),
					Array (26, 50, 31.5),
					Array (51, 75, 28),
					Array (76, 100, 26.5),
					Array (101, 150, 24),
					Array (151, 250, 21.5),
					Array (251, 350, 20.5),
					Array (351, 500, 19.8),
					Array (501, 750, 18.5),
					Array (751, 1000, 17),
					Array (1001, 1500, 15),
					Array (1501, 2000, 12),
					Array (2001, 3000, 10),
					Array (3001, 5000, 7.5),
					Array (5001, 10000, 5)
				)
			),
			Array(
				"MAPILab File Recovery", Array(
					Array (10, 25, 35),
					Array (26, 50, 31.5),
					Array (51, 75, 28),
					Array (76, 100, 26.5),
					Array (101, 150, 24),
					Array (151, 250, 21.5),
					Array (251, 350, 20.5),
					Array (351, 500, 19.8),
					Array (501, 750, 18.5),
					Array (751, 1000, 17),
					Array (1001, 1500, 15),
					Array (1501, 2000, 12),
					Array (2001, 3000, 10),
					Array (3001, 5000, 7.5),
					Array (5001, 10000, 5)
				)
			)
		)
	),
	Array(
		"Outlook Express Add-ins", Array(
			Array(
				"Mail Recovery for OE", Array(
					Array (101, 150, 5),
					Array (151, 250, 4),
					Array (251, 350, 3.5),
					Array (351, 500, 3),
					Array (501, 750, 2.8),
					Array (751, 1000, 2.4),
					Array (1001, 1500, 2),
					Array (1501, 2000, 1.7),
					Array (2001, 3000, 1.5),
					Array (3001, 5000, 1.2),
					Array (5001, 10000, 1)
				)
			),
			Array(
				"Attachments Processor for OE", Array(
					Array (101, 150, 5),
					Array (151, 250, 4),
					Array (251, 350, 3.5),
					Array (351, 500, 3),
					Array (501, 750, 2.8),
					Array (751, 1000, 2.4),
					Array (1001, 1500, 2),
					Array (1501, 2000, 1.7),
					Array (2001, 3000, 1.5),
					Array (3001, 5000, 1.2),
					Array (5001, 10000, 1)
				)
			),

			Array(
				"Remove Duplicates from OE", Array(
					Array (101, 150, 5),
					Array (151, 250, 4),
					Array (251, 350, 3.5),
					Array (351, 500, 3),
					Array (501, 750, 2.8),
					Array (751, 1000, 2.4),
					Array (1001, 1500, 2),
					Array (1501, 2000, 1.7),
					Array (2001, 3000, 1.5),
					Array (3001, 5000, 1.2),
					Array (5001, 10000, 1)
				)
			),
			Array(
				"Send Personally for OE", Array(
					Array (101, 150, 5),
					Array (151, 250, 4),
					Array (251, 350, 3.5),
					Array (351, 500, 3),
					Array (501, 750, 2.8),
					Array (751, 1000, 2.4),
					Array (1001, 1500, 2),
					Array (1501, 2000, 1.7),
					Array (2001, 3000, 1.5),
					Array (3001, 5000, 1.2),
					Array (5001, 10000, 1)
				)
			)
		)
	),
Array(
"Groupware Solutions for Microsoft Outlook", Array(
Array(
"MAPILab Groupware Server", Array(
Array (26, 30, 31),
Array (31, 40, 28),
Array (41, 50, 25.5),
Array (51, 75, 22),
Array (76, 100, 19)
)
)
)
),
Array(
"Microsoft Excel Add-ons", Array(
Array(
"Advanced Consolidation Manager", Array(
Array (11, 15, 24),
Array (16, 20, 23.2),
Array (21, 25, 22.5),
Array (26, 30, 21.8),
Array (31, 40, 21.2),
Array (41, 50, 20.5),
Array (51, 75, 19),
Array (76, 100, 17.5)
)
),
Array(
"MAPILab Find and Replace for Excel", Array(
Array (11, 15, 24),
Array (16, 20, 23.2),
Array (21, 25, 22.5),
Array (26, 30, 21.8),
Array (31, 40, 21.2),
Array (41, 50, 20.5),
Array (51, 75, 19),
Array (76, 100, 17.5)
)
),
Array(
"Remove Duplicates from Excel", Array(
Array (11, 15, 24),
Array (16, 20, 23.2),
Array (21, 25, 22.5),
Array (26, 30, 21.8),
Array (31, 40, 21.2),
Array (41, 50, 20.5),
Array (51, 75, 19),
Array (76, 100, 17.5)
)
),
Array(
"Similar Data Finder for Excel", Array(
Array (11, 15, 24),
Array (16, 20, 23.2),
Array (21, 25, 22.5),
Array (26, 30, 21.8),
Array (31, 40, 21.2),
Array (41, 50, 20.5),
Array (51, 75, 19),
Array (76, 100, 17.5)
)
),
Array(
"Tables Transformer", Array(
Array (11, 15, 24),
Array (16, 20, 23.2),
Array (21, 25, 22.5),
Array (26, 30, 21.8),
Array (31, 40, 21.2),
Array (41, 50, 20.5),
Array (51, 75, 19),
Array (76, 100, 17.5)
)
),
Array(
"Compare Spreadsheets for Excel", Array(
Array (11, 15, 29),
Array (16, 20, 28.2),
Array (21, 25, 27.5),
Array (26, 30, 26.8),
Array (31, 40, 25.5),
Array (41, 50, 24),
Array (51, 75, 22.3),
Array (76, 100, 21)
)
),
Array(
"Fix Broken Links", Array(
Array (11, 15, 29),
Array (16, 20, 28.2),
Array (21, 25, 27.5),
Array (26, 30, 26.8),
Array (31, 40, 25.5),
Array (41, 50, 24),
Array (51, 75, 22.3),
Array (76, 100, 21)
)
)
)
)
);


$(document).ready( function () {
	$("select[@name=category]").change(function () {
		cat_id = $("select[@name=category] option:selected").attr("value");
		$("select[@name=product]").empty();
		$("#min_quantity").empty();
		$("input[@name=quantity]").attr("disabled","disabled");
		$("input[@name=calculate]").attr("disabled","disabled");
		if(cat_id != "none")
		{
			$("select[@name=product]").removeAttr("disabled");
			
			products = data[cat_id][1];
			
			$.each(products, function(k, pn) {
				$("<option value='"+ k +"'>" + pn[0] + "</option>").appendTo("select[@name=product]");
				
			});
			$("<option value='none' selected>- Bitte w&auml;hlen -</option>").prependTo("select[@name=product]");
			$("select[@name=product]")[0].selectedIndex = 0;
		}
		else
		{
			$("select[@name=product]").attr("disabled","disabled");
        		$("<option value='none' selected>- Bitte w&auml;hlen -</option>").prependTo("select[@name=product]");
		}
	});
	
	
	$("select[@name=product]").change(function () {
		prod_id = $("select[@name=product] option:selected").attr("value");
		if(prod_id != "none")
		{
			$("input[@name=quantity]").removeAttr("disabled");
			$("input[@name=calculate]").removeAttr("disabled");
			$("#min_quantity").html("Die Mindestmenge f&uuml;r dieses Produkt ist "+ data[cat_id][1][prod_id][1][0][0]);
		}
		else
		{
			$("input[@name=quantity]").attr("disabled","disabled");
			$("input[@name=calculate]").attr("disabled","disabled");
			$("#min_quantity").empty();
		}
	});
	
	var options = "<option value='none' selected>- Bitte w&auml;hlen -</option>";
	
	$.each(data, function(i, n){
		options += "<option value='"+ i +"'>" + n[0] + "</option>";
	});
	$(options).appendTo("select[@name=category]");
	$("select[@name=category]")[0].selectedIndex = 0;
});


function UpdateTotalPrice() {
	var price = "";
	var total_price = "";
	var quantity = $("input[@name=quantity]")[0].value;
	
	if(isInt(quantity) && quantity >= data[cat_id][1][prod_id][1][0][0])
	{
		$("#results").show();
	
		$.each(data[cat_id][1][prod_id][1], function (i,n) {
			if(quantity >= n[0] && quantity <= n[1]) {
				price = n[2];
				return false;
			}
			else
			{
				price = false;
			}
		});
		
		if(price)
		{
			total_price = price*quantity;
			
			$("#info").empty();
			$("<div>Produkt: " + data[cat_id][1][prod_id][0] + "</div>").appendTo("#info");
			$("<div>Menge: " + quantity + "</div>").appendTo("#info");
			$("<div>Preis f&uuml;r eine Lizenz: &euro;" + price + "</div>").appendTo("#info");
			
			$("#total_price").html("Gesamtpreis: &euro;" + total_price);
			
			var result = "Produkt: " + data[cat_id][1][prod_id][0] + "\n" +
			"Menge: " + quantity + "\n" +
			"Preis f&uuml;r eine Lizenz: " + price + "EURO \n" +
			"Gesamtpreis: " + total_price + "EURO \n";
			
			$("input[@name=results]").val(result);
		}
		else
		{
			$("#info").empty();
			$("<div>Produkt: " + data[cat_id][1][prod_id][0] + "</div>").appendTo("#info");
			$("<div>Menge: " + quantity + "</div>").appendTo("#info");
			$("#total_price").html("Sonderkonditionen. Bitte wenden Sie sich an uns.");
			
			var result = "Produkt: " + data[cat_id][1][prod_id][0] + "\n" +
			"Menge: " + quantity + "\n" +
			"Preis: Sonderkonditionen \n";
			
			$("input[@name=results]").val(result);
		}
	}
	else
	{
		alert('Bitte ueberpruefen Sie das Feld "Menge"');
	}
}


function isInt(x) {
	var y=parseInt(x);
	if (isNaN(y)) return false;
	return x==y && x.toString()==y.toString();
}