/* key: Name[0] SIZE[1] CODE[2] SSP[3] BARCODE[4] */
var intProducts = 74;
var arrProduct0 = Array("PREMIUM SLICED BREAD","","","","")
var arrProduct1 = Array("KM GOOD AS GOLD SOFT WHITE","800g","938","113","5010092093847")
var arrProduct2 = Array("KM GOOD AS GOLD MALTED GRAIN","800g","939","118","5010092093946")
var arrProduct3 = Array("ALLINSON WHOLEMEAL BATCH","800g","2457","112","5010092245741")
var arrProduct4 = Array("EVERYDAY SLICED BREAD","","","","")
var arrProduct5 = Array("KM GREAT EVERYDAY SOFT WHITE (MED)","800g","930","102","5010092093045")
var arrProduct6 = Array("KM GREAT EVERYDAY SOFT WHITE (THK)","800g","931","102","5010092093144")
var arrProduct7 = Array("KM TOASTIE THICK","800g","960","109","5010092096046")
var arrProduct8 = Array("KM GREAT EVERYDAY TASTY WM (MED)","800g","932","106","5010092093243")
var arrProduct9 = Array("KM GREAT EVERYDAY TASTY WM (THK)","800g","933","106","5010092093342")
var arrProduct10 = Array("KM CRUSTS AWAY! (white)","400g","793","115","5010092079346")
var arrProduct11 = Array("KM CRUSTS AWAY! (50/50)","400g","795","115","5010092079544")
var arrProduct12 = Array("SUNBLEST WHITE (MED)","800g","4470","83","5010092447046")
var arrProduct13 = Array("SUNBLEST WHITE (THK)","800g","4471","83","5010092447145")
var arrProduct14 = Array("SUNBLEST BROWN","800g","14","85","5010092001408")
var arrProduct15 = Array("KM PLAIN","800g","959","106","5010092095940")
var arrProduct16 = Array("SUNBLEST SCOTTISH PLAIN","800g","17","95","5010092001705")
var arrProduct17 = Array("HEALTHIER SLICED BREAD","","","","")
var arrProduct18 = Array("KM HEAD START OMEGA 3","800g","843","119","5010092084340")
var arrProduct19 = Array("KM 50/50 (THK)","800g","979","110","5010092097944")
var arrProduct20 = Array("KM 50/50 (MED)","800g","934","110","5010092093441")
var arrProduct21 = Array("BURGEN WHGRAIN & CRANBERRY","800g","533","133","5010092053346")
var arrProduct22 = Array("BURGEN SOYA & LINSEED","800g","2158","133","5010092215842")
var arrProduct23 = Array("SMALL SLICED BREAD","","","","")
var arrProduct24 = Array("KM GREAT EVERYDAY SOFT WHITE","400g","941","68","5010092094141")
var arrProduct25 = Array("KM GREAT EVERYDAY TASTY WM","400g","942","72","5010092094240")
var arrProduct26 = Array("ALLINSON SMALL WHOLEMEAL","400g","2483","76","5010092248346")
var arrProduct27 = Array("EVERYDAY WHITE ROLLS","","","","")
var arrProduct28 = Array("KM WHITE ROLLS","6 pack","519","89","5010092051922")
var arrProduct29 = Array("KM SLICED ROLLS","12 pack","2149","136","5010092214945")
var arrProduct30 = Array("SUNBLEST WHITE ROLLS","12 pack","476","127","5010092047604")
var arrProduct31 = Array("KM BIG SOFT ROLLS","4 pack","5716","93","5010092571642")
var arrProduct32 = Array("BREADCAKES","6 pack","130","92","5010092013005")
var arrProduct33 = Array("SCOTTISH MORNING ROLL","6 pack","3326","80","5010092332601")
var arrProduct34 = Array("MORNING ROLL","SGL","3233","16","5010092323302")
var arrProduct35 = Array("EVERYDAY NON-WHITE ROLLS","","","","")
var arrProduct36 = Array("KM TASTY WHOLEMEAL ROLLS","6 pack","583","100","5010092058341")
var arrProduct37 = Array("BROWN MORNING ROLL","SGL","3231","18","5010092323104")
var arrProduct38 = Array("PREMIUM ROLLS","","","","")
var arrProduct39 = Array("KM 50/50 ROLLS","6 pack","969","93","5010092096947")
var arrProduct40 = Array("KM HEAD START OMEGA 3 ROLLS","6 pack","845","110","5010092084548")
var arrProduct41 = Array("OVEN BOTTOM MUFFIN","4 pack","3649","80","5010092364947")
var arrProduct42 = Array("SUNBLEST SOFTIES","4 pack","3193","80","5010092319343")
var arrProduct43 = Array("SCOTTISH BUTTERY","4 pack","367","91","5000404103050")
var arrProduct44 = Array("LOOSE HARD FIRED ROLL","SGL","3259","16","5010092325900")
var arrProduct45 = Array("ROLLS FOR OCCASSION","","","","")
var arrProduct46 = Array("SUNBLEST FINGER ROLL","6 pack","172","89","5010092017201")
var arrProduct47 = Array("SWEET TREAT SNACKS","","","","")
var arrProduct48 = Array("SUNBLEST SCOTCH PANCAKES","6 pack","151","89","5010092015108")
var arrProduct49 = Array("SUNBLEST CURRANT BUNS","4 pack","180","92","5010092018000")
var arrProduct50 = Array("SUNBLEST TEACAKES","4 pack","181","90","5010092018109")
var arrProduct51 = Array("KM PANCAKES","6 pack","1535","103","5010092153541")
var arrProduct52 = Array("KM LARGE PANCAKES","4 pack","56","116","5010092005642")
var arrProduct53 = Array("KM HOT X BUNS","4 pack","1515","97","5010092151547")
var arrProduct54 = Array("SUNBLEST SULTANA SCONES","4 pack","3493","104","5010092349340")
var arrProduct55 = Array("KM FLIPPITZ CHOCOLATE","5 pack","813","125","5010092081349")
var arrProduct56 = Array("KM FLIPPITZ STAWBERRY","5 pack","812","125","5010092081240")
var arrProduct57 = Array("BREAKFAST BAKERY SNACKS","","","","")
var arrProduct58 = Array("KM POTATO SCONES","6 pack","538","116","5010092053841")
var arrProduct59 = Array("SUNBLEST POTATO SCONES","6 pack","1923","81","5010092192342")
var arrProduct60 = Array("SAVOURY BAKERY SNACKS","","","","")
var arrProduct61 = Array("KM CRUMPETS","6 pack","1525","88","5010092152544")
var arrProduct62 = Array("KM MUFFINS","4 pack","1529","103","5010092152940")
var arrProduct63 = Array("SUNBLEST CRUMPETS","8 pack","491","70","5010092019809")
var arrProduct64 = Array("SUNBLEST ENGLISH MUFFINS","6 pack","190","103","5010092019007")
var arrProduct65 = Array("KM SCOTTISH CRUMPETS","6 pack","543","116","5010092054343")
var arrProduct66 = Array("BREADS OF THE WORLD","","","","")
var arrProduct67 = Array("FLAT BREAD PLAIN PITTA","6 pack","3890","104","5021546710050")
var arrProduct68 = Array("FLAT BREAD PLAIN NAAN","2 pack","3887","114","5021546710005")
var arrProduct69 = Array("OTHER NON-CORE SNACKS","","","","")
var arrProduct70 = Array("SUNBLEST SCT SODA SCONES","4 pack","2535","75","5010092153548")
//var arrProduct71 = Array("SUNMALT FAMILY MALT","1","1254","89","5010092125449")
var arrProduct71 = Array("SOREEN LARGE MALT LOAF","800g","3038","99","5010092125449")
var arrProduct72 = Array("ECCLES CAKES 4X12","c/s","3081","1752","-")
var arrProduct73 = Array("SUNBLEST CHELSEA BUNS","4 pack","5216","126","5010092521647")
var arrProduct74 = Array("SNOWBALLS","4 pack","366","125","5010092036608")
function CurrencyFormatted(amount)
{
	//http://www.web-source.net/web_development/currency_formatting.htm
	var i = parseFloat(amount);
	if(isNaN(i)) { i = 0.00; }
	var minus = '';
	if(i < 0) { minus = '-'; }
	i = Math.abs(i);
	i = parseInt((i + .005) * 100);
	i = i / 100;
	s = new String(i);
	if(s.indexOf('.') < 0) { s += '.00'; }
	if(s.indexOf('.') == (s.length - 2)) { s += '0'; }
	s = minus + s;
	return s;
}
function createProductSelect(){
	document.write('<select name="prodList" class="calc_select" onChange="javascript:getValues(this.selectedIndex);">')
	for(i=0;i<intProducts;i++){
		var arrCurrProduct = Array();
		var sLabel;
		var prodID;
		var sWeight;
		arrCurrProduct = eval('arrProduct'+i)
		if(arrCurrProduct[1]==''){
			sLabel = "-- "+arrCurrProduct[0]
			sWeight = "--"
			prodID = -1
		}else{
			prodID = i
			sLabel = arrCurrProduct[0]
			sWeight = arrCurrProduct[1]
			
		}
		document.write('<option id=' + prodID +'>' + sLabel + ' ' + sWeight +'</option>')
	}
	document.write('</select><br />')
}
var intPrevSelected = 0;
var intCurrABSSP = 0;
function getValues(optionID){
	//alert(optionID)
	var prodName = ""
	var prodID = document.fmSSP.prodList.options[optionID].id;
	if(prodID==-1){
		document.fmSSP.prodList.selectedIndex = intPrevSelected;
	}else{
		document.getElementById('results').style.display = "none";
		document.getElementById('intRetailerPay').value = ""
		document.getElementById('intUnitsPerDay').value = ""
		document.getElementById('intRetailerSells').value = ""
		intPrevSelected = optionID;
		intCurrABSSP = eval('arrProduct'+prodID+'[3]')/100
		document.getElementById('intABSSP').innerHTML = "<strong>&pound;" + intCurrABSSP + "</strong>"
	}
}
function doCalc(){
	var intRetailerPay = document.getElementById('intRetailerPay').value
	var intUnitsPerDay = document.getElementById('intUnitsPerDay').value
	var intRetailerSells = document.getElementById('intRetailerSells').value
	var intABSSP = intCurrABSSP
	//validate
	if(intRetailerPay==''||intUnitsPerDay==''||intRetailerSells==''){
		alert('Please complete the form')
	}else if(isNaN(intRetailerPay)){
		alert('You pay for product (p): is not a number')
	}else if(isNaN(intUnitsPerDay)){
		alert('Units sold per day: is not a number')
	}else if(isNaN(intRetailerSells)){
		alert('You sell product (p): is not a number')
	}else{
		var intWeeklyVolume = (intUnitsPerDay*7)
		var intTotalWeeklyRevenue = (intRetailerSells-intRetailerPay)*intWeeklyVolume
		var intTotalWeeklyRevenueAB = (intABSSP-intRetailerPay)*intWeeklyVolume
		var intTotalDifference = intTotalWeeklyRevenueAB - intTotalWeeklyRevenue
		document.getElementById('results').style.display = "block";
		document.getElementById('intWeeklyVolume').innerHTML = "<strong>"+intWeeklyVolume+"</strong>"
		document.getElementById('intTotalWeeklyRevenue').innerHTML = "<strong>&pound;"+CurrencyFormatted(intTotalWeeklyRevenue)+"</strong>"
		document.getElementById('intTotalWeeklyRevenueAB').innerHTML = "<strong>&pound;"+CurrencyFormatted(intTotalWeeklyRevenueAB)+"</strong>"
		document.getElementById('intTotalDifference').innerHTML = "<strong>&pound;"+CurrencyFormatted(intTotalDifference)+"</strong>"
		
	}
}

function createCalculator(){
	document.write('<form name="fmSSP">');
	document.write('<table class="calc_table">')
	document.write('<tr><td>')
	createProductSelect();
	document.write('</td></tr>')
	document.write('<tr><td><table><tr><td valign="top" colspan="2">')	
	
		
	document.write('<TR><TD width="215"><span class="calc_text">You pay for product (.pp): </span><br /></TD><TD width="75"><input type="text" class="calc_data" id="intRetailerPay" /><br /></TD></TR>')
	document.write('<TR><TD width="215"><span class="calc_text">You sell product for (.pp): </span><br /></TD><TD width="75"><input type="text" class="calc_data" id="intRetailerSells" /></TD></TR>')
	document.write('<TR><TD width="215"><span class="calc_text">No. of products sold per day: </span><br /></TD><TD width="75"><input type="text" class="calc_data" id="intUnitsPerDay" /></TD></TR>')
	document.write('<TR><TD width="215"><span class="calc_text"><input type="button" value="calculate" class="calc_button" onClick="doCalc();" /></span></TD><TD width="75">&nbsp;</TD></TR>')
	document.write('</td></tr></table></td><tr><td valign="top">')
	
	document.write('<div id="results" style="display:none;">')
	document.write('<table>');
	document.write('<TR><TD width="215"><span class="calc_text">Allied Bakery SSP:</span></TD><TD width="75"><span class="calc_text"><div id="intABSSP"></div></TD></TR>')
	document.write('<tr><td width="215"><span class="calc_text">Weekly volume sold:</span></TD><td width="75"><span class="calc_text"><div id="intWeeklyVolume"></div></span></TD></TR>')
	document.write('<tr><td width="215"><span class="calc_text">Weekly revenue (your SSP):</span></TD width="75"><td><span class="calc_text"><div id="intTotalWeeklyRevenue"></div></span></TD></TR>')
	document.write('<tr><td width="215"><span class="calc_text">Weekly revenue (Our SSP):</span></TD><td width="75"><span class="calc_text"><div id="intTotalWeeklyRevenueAB"></div></span></TD></TR>')
	document.write('<tr><td width="215"><span class="calc_text">Total difference:</span></TD><td width="75"><span class="calc_text"><div id="intTotalDifference"></div></span></TD></TR>')
	document.write('</table>')
	document.write('</div>')
	document.write('</td></tr></table>')
	document.write('</form>');

	document.fmSSP.prodList.selectedIndex=1; //select the first valid product item
	getValues(1); //init the values for the first valid product item
}

createCalculator();