/*
            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 ( Hours Control File )
var minus=0;
var dbarray= new Array();
var NoOfLines=0;
var NoOfFields=0;
var no1=0;//Suday
var no2=0;//Monday
var no3=0;//Tuesday
var no4=0;//Wednesday
var no5=0;//Thursday
var no6=0;//Friday
var no7=0;//Saturday
var numline=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",""+"Hour_controlfile/hours.txt", false); xml.send(null);

var readtext=xml.responseText;

dbarray=readtext.split("~");
NoOfLines=(dbarray.length - 2)/7; //Divide by number of fields
NoOfFields=dbarray.length - 1;
}

//Draw the table
function DrawProductsTablesFromDBArray(){
minus=7; //Skip first row of Control File  = Number of Columns
minus1=5; //Skip first row of Menu Items = Number of Columns
var i = 0; //Counter for items, we don't want it to reset

//
var newtable='';
var susession='';
var newtable='';
//



// Loop through ControlFile db skipping first row.
for (var ii = 0; ii <= NoOfLines-1; ii++)//ii is line number
{

//Control File
no1=eval(ii + 0 + minus);
no2=eval(ii + 1 + minus);
no3=eval(ii + 2 + minus);
no4=eval(ii + 3 + minus);
no5=eval(ii + 4 + minus);
no6=eval(ii + 5 + minus);
no7=eval(ii + 6 + minus);

if (ii == 1){susession='not '};

newtable=newtable + '<table border="0">'+
'<tr><td colspan="2"><b>SU ' + susession + 'in Session</b></td></tr>' +
'<tr><td style="padding-left:10px;">Sunday</td><td>' + dbarray[no1] + '</td></tr>' +
'<tr><td style="padding-left:10px;">Monday</td><td>' + dbarray[no2] + '</td></tr>' +
'<tr><td style="padding-left:10px;">Tuesday</td><td>' + dbarray[no3] + '</td></tr>' +
'<tr><td style="padding-left:10px;">Wednesday</td><td>' + dbarray[no4] + '</td></tr>' +
'<tr><td style="padding-left:10px;">Thursday</td><td>' + dbarray[no5] + '</td></tr>' +
'<tr><td style="padding-left:10px;">Friday</td><td>' + dbarray[no6] + '</td></tr>' +
'<tr><td style="padding-left:10px;">Saturday</td><td>' + dbarray[no7] + '</td></tr>' +
'</table><br>';

minus=minus+6; //The plus is = to columns - 1
}

var html=newtable;

if (document.getElementById)
{ document.getElementById('layer2').innerHTML= html; }
else { with (document.layers['layer2'].document)
 { open();
 write(html); close();
}
}
}

//Execute Functions from this point
ReadDbLoadToArrays();
DrawProductsTablesFromDBArray()