/* To add a column to db you need to change the following: 1. Add global variable for new column 2. Add column variable to drawing function 3. Increase the "minus' variable by the number of new columns There should be as many column rows as category rows in the text files */ //Glogal Variables //First DB Load Function ( Menu Control File ) var minus=0; var dbarray= new Array(); var NoOfLines=0; var NoOfFields=0; var no1=0;//Categories var no2=0;//Description var no3=0;//Number of Columns var no4=0;//Number of Items //var no5=0;//Column Label Y or N var numline=0; //Second DB Load Function ( Menu Items ) var minus1=0; var dbarray1= new Array(); var NoOfLines1=0; var NoOfFields1=0; var no1_1=0;//description var no2_1=0;//price1 var no3_1=0;//price2 var no4_1=0;//price3 var no5_1=0;//price4 var numline1=0; //Third DB Load Function ( Column Labels ) var minus2=0; var dbarray2= new Array(); var NoOfLines2=0; var NoOfFields2=0; var no1_2=0;//Column Label 1 var no2_2=0;//Column Label 2 var no3_2=0;//Column Label 3 var no4_2=0;//Column Label 4 var numline2=0; function removeSpaces(string) { return string.split(' ').join(''); } function removeNL(s) { // // Remove NewLine, CarriageReturn and Tab characters from a String // s string to be processed // returns new string // r = ""; for (i=0; i < s.length; i++) { if (s.charAt(i) != '\n' && s.charAt(i) != '\r' && s.charAt(i) != '\t') { r += s.charAt(i); } } return r; } //Load Control File function ReadDbLoadToArrays(){ var xml=false; // JScript gives us Conditional compilation, we can cope with old IE versions. // and security blocked creation of the objects. it works in IE and Mozilla try { xml = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { xml = new ActiveXObject("Microsoft.XMLHTTP"); } catch (E) { xml = false; } } if (!xml && typeof XMLHttpRequest!='undefined') { xml = new XMLHttpRequest(); //alert("MOZILLA"); }else { }//ie alert("not MOZILLA"); // xml.open("GET",""+document.title+"/"+document.title+".txt", false); xml.send(null); //Original xml.open("GET",""+"MainMenu_Items/menuControl.txt", false); xml.send(null); var readtext=xml.responseText; dbarray=readtext.split("~"); NoOfLines=(dbarray.length - 2)/4; //Divide by number of fields NoOfFields=dbarray.length - 1; } //Load Menu Items function ReadDbLoadToArrays1(){ var xml=false; // JScript gives us Conditional compilation, we can cope with old IE versions. // and security blocked creation of the objects. it works in IE and Mozilla try { xml = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { xml = new ActiveXObject("Microsoft.XMLHTTP"); } catch (E) { xml = false; } } if (!xml && typeof XMLHttpRequest!='undefined') { xml = new XMLHttpRequest(); //alert("MOZILLA"); }else { }//ie alert("not MOZILLA"); // xml.open("GET",""+document.title+"/"+document.title+".txt", false); xml.send(null); //Original xml.open("GET",""+"MainMenu_Items/menuItems.txt", false); xml.send(null); var readtext1=xml.responseText; dbarray1=readtext1.split("~"); NoOfLines1=(dbarray1.length - 2)/4; //Divide by number of fields NoOfFields1=dbarray1.length - 1; } //Load Column Labels function ReadDbLoadToArrays2(){ var xml=false; // JScript gives us Conditional compilation, we can cope with old IE versions. // and security blocked creation of the objects. it works in IE and Mozilla try { xml = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { xml = new ActiveXObject("Microsoft.XMLHTTP"); } catch (E) { xml = false; } } if (!xml && typeof XMLHttpRequest!='undefined') { xml = new XMLHttpRequest(); //alert("MOZILLA"); }else { }//ie alert("not MOZILLA"); // xml.open("GET",""+document.title+"/"+document.title+".txt", false); xml.send(null); //Original xml.open("GET",""+"MainMenu_Items/priceColumnLabels.txt", false); xml.send(null); var readtext2=xml.responseText; dbarray2=readtext2.split("~"); NoOfLines2=(dbarray2.length - 2)/4; //Divide by number of fields NoOfFields2=dbarray2.length - 1; } //Draw the table function DrawProductsTablesFromDBArray(){ minus=4; //Skip first row of Control File = Number of Columns minus1=5; //Skip first row of Menu Items = Number of Columns minus2=4; //Skip first row of Column Labels = Number of Columns var i = 0; //Counter for items, we don't want it to reset // var basketbar=''; var newtable=''; var labelExists='false'; // // Loop through ControlFile db skipping first row. for (var ii = 0; ii <= NoOfLines-1; ii++)//ii is line number { //Control File labelExists='false'; no1=eval(ii + 0 + minus); no2=eval(ii + 1 + minus); no3=eval(ii + 2 + minus); no4=eval(ii + 3 + minus); //Column Labels no1_2=eval(ii + 0 + minus2); no2_2=eval(ii + 1 + minus2); no3_2=eval(ii + 2 + minus2); no4_2=eval(ii + 3 + minus2); newtable=''+ ' ' + ''+ ''+ '
'+ '

'+removeNL(dbarray[no1])+'

[hide/show]

'+ ' '+removeNL(dbarray[no2])+'

'+ ''+ '

 

'; basketbar=basketbar+newtable; } var html=basketbar; //alert(html); if (document.getElementById) { document.getElementById('layer1').innerHTML= html; } else { with (document.layers['layer1'].document) { open(); write(html); close(); } } } //Execute Functions from this point ReadDbLoadToArrays(); ReadDbLoadToArrays1(); ReadDbLoadToArrays2(); DrawProductsTablesFromDBArray()