$(document).ready( function(){
	fillProdTbl();
	makeOrder();
});

function fillProdTbl(){
	$("table[excelFile]").each( function() {
		var that = this;
		if($(this).attr("excelFile") != ""){
			$.post('readExcel.php', {
					excelFile : 'files/' + $(this).attr("excelFile")
			}, function(data){
				var rows = data.split("\n");
				var currentArtNr = 0;
				for(var i in rows){
					if(i < rows.length-1){
						var cols = rows[i].split(";:;");
						var newRow = "\n<tr>";
						for(var n in cols){
						  if(n < cols.length-1){
							switch(parseInt(n)){
								case 0: 
									newRow += '<td><input type="hidden" name="artNr" value="' + cols[n] + '">';
									currentArtNr = cols[n];
									break;
								case 1: 
									newRow += '<td><input type="hidden" name="mod" value="' + cols[n] + '">'; 
									break;
								case 2: 
									newRow += '<td><input type="hidden" name="size" value="' + cols[n] + '">'; 
									break;
								case 3: 
									newRow += '<td><input type="hidden" name="description" value="' + cols[n] + '">'; 
									break;
								case 4: 
									newRow += '<td><input type="hidden" name="saftyLvl" value="' + cols[n] + '">'; 
									break;
								default : 
									newRow += '<td>';
							}
							newRow += cols[n] + "</td>";
						  }
						}
						var addNewRowText = $("div.langExtras").attr("addNewRow");
						$(that).html($(that).html() + newRow + '<td><input type="text" value="" name="stl" size="5" /></td><td><input type="text" name="ammount"  size="5" /></td></tr><tr><td colspan="7" align="right" style="border-bottom: 1px solid #000000; padding: 3px;"><a style="text-decoration: none; cursor: pointer;" artNr="' + currentArtNr + '" class="addProdRow" href="javascript:addProdRow(' + i + ');"><img src="images2/plusbutton.png" border="0" width="11" valign="top" style="position: relative; top: 2px;"> ' + addNewRowText + '</a></td></tr>\n');
					}
				}
				
			});
		}
		
		
	});
}


function makeOrder(){

	$("input[type=button][makeOrder=true]").click( function() {
	var artNr = Array();
	var stl = Array();
	var ammount = Array();
	var mod = Array();
	var description = Array();
	var saftyLvl = Array();
	
	
		$("input[name=ammount]").each( function() {
			if(parseInt($(this).attr("value")) > 0   && $(this).parent().parent().find("input[name=stl]").attr("value").length > 0){
				artNr.push($(this).parent().parent().find("input[name=artNr]").attr("value"));
				mod.push($(this).parent().parent().find("input[name=mod]").attr("value"));
				saftyLvl.push($(this).parent().parent().find("input[name=saftyLvl]").attr("value"));
				description.push($(this).parent().parent().find("input[name=description]").attr("value"));
				ammount.push($(this).attr("value"));
				stl.push($(this).parent().parent().find("input[name=stl]").attr("value"));
			}
		});
		
		var orderNr = $(this).parents("form").find("input[name=orderNr]").attr("value");
		var customerId = $(this).parents("form").find("input[name=customerId]").attr("value");
		var email = $(this).parents("form").find("input[name=email]").attr("value");
		var tel = $(this).parents("form").find("input[name=tel]").attr("value");
		var error = false;
		
		if(customerId == ""){
			$(this).parents("form").find("input[name=customerId]").css("background-color","#ff3f3f");
			error = true;
		}
		
		if(email == ""){
			$(this).parents("form").find("input[name=email]").css("background-color","#ff3f3f");
			error = true;
		}
		
		if(artNr.length == 0)
			error = true;
		
		if(!error)
			createSubmitionForm(artNr, stl, ammount, saftyLvl, description, orderNr, customerId, email, tel);		
	});
}

function addProdRow(i){
	var that = $("table[excelFile]").find(".addProdRow").get(i);
	var delNewRowText = $("div.langExtras").attr("delNewRow");
	var artNr = $(that).attr("artNr");
	$(that).parent().parent().before('<tr><td colspan="5" align="right"><a onclick="$(this).parent().parent().remove();" style="text-decoration: none; cursor: pointer"><img src="images2/minusbutton.png" border="0" width="11" style="position: relative; top: 2px;"> ' + delNewRowText + '</a></td><td><input type="hidden" name="artNr" value="' + artNr + '"><input type="text" name="stl" size="5" /></td><td><input type="text" name="ammount"  size="5" /></td></tr>');
}

function createSubmitionForm(artNr, stl, ammount, saftyLvl, description, orderNr, customerId, email, tel){
	
	var formContent = '<form action="makeOrder.lasso" method="post" name="newOrderForm">';
	formContent += '<input type="hidden" name="artNr" value="' + artNr + '" />\n';
	formContent += '<input type="hidden" name="stl" value="' + stl + '" />\n';
	formContent += '<input type="hidden" name="ammount" value="' + ammount + '" />\n';
	formContent += '<input type="hidden" name="description" value="' + description + '" />\n';
	formContent += '<input type="hidden" name="saftyLvl" value="' + saftyLvl + '" />\n';
	formContent += '<input type="hidden" name="orderNr" value="' + orderNr + '" />\n';
	formContent += '<input type="hidden" name="customerId" value="' + customerId + '" />\n';
	formContent += '<input type="hidden" name="email" value="' + email + '" />\n';
	formContent += '<input type="hidden" name="tel" value="' + tel + '" />\n';
	formContent += '</form>\n';
	
	$(".newOrderForm").html(formContent);
	
	$("form[name=newOrderForm]").submit();
}