// Need to use this
 //if (typeof(ctrl) != "undefined") {

 function passValues(fieldID, selectedValue, selectedID)
 {
 
   var descField = eval("opener.document.forms[0].field_desc_" + fieldID);
   var idField = eval("opener.document.forms[0].field_" + fieldID);
   
   descField.value = selectedValue;
   idField.value = selectedID;    
 } 
 function showPopupPage(href)
 {
   var wOpen = window.open(href);
 }
 function redirectPage(obj)
 {
   document.forms[0].updated.value = "N";
   document.forms[0].submit();
 }

  function validateMultiple(obj)
  {
     if(obj.selectedIndex == 0)
	obj.selectedIndex = 0;  
  }


  function openDateWindow(sendToObj)
  {  
     
    // need to figure out where object is 
    
    var left = 250;
    var top = 150;
    var activeCalendar = eval("document.all('calendar');");    
    activeCalendar.style.left = left;
    activeCalendar.style.top = top;
    activeCalendar.style.visibility = 'visible';
    
    var today = new Date();    
    showCalendarMonth(today.getMonth() + 1, today.getFullYear(), sendToObj);    
  }  
  
  function closeDateWindow()
  {
	var activeCalendar = eval("document.all('calendar');");    
	activeCalendar.style.visibility = 'hidden';
  }
      
  function showCalendarMonth(month, year, sendToObj)
  {    
    var monthArray = new Array('January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December');     
	var myDate = new Date(month + "/01/" + year);
	month = myDate.getMonth();
	
    var content = "<table cellspacing=0 cellpadding=0 border=0 width=100%><tr height=20>";        
    var currentDate;
       
    for (var i = 0; i < myDate.getUTCDay(); i++)
    {
      content += "<td></td>";
    }
    
    while (myDate.getMonth() == month)
    {
        
        if (myDate.getUTCDay() == 0)
           content += "<tr height=20>"
               
        currentDate = (myDate.getMonth() + 1) + "/" + myDate.getDate() + "/" + (myDate.getFullYear());
        
        content += "<td align=center width=25 class=calendarDay><a href='javascript:setDate(\"" + currentDate + "\"," + sendToObj + ")'>" + myDate.getDate() + "</a></td>";        		

        if (myDate.getUTCDay() == 6)
           content += "</tr>"
        
		myDate.setDate(myDate.getDate() + 1);		
    }
    content += "</table>";
    
    document.getElementById("month").innerHTML = monthArray[month] + " " + year;
    document.getElementById("calendarDays").innerHTML = content;
 
  }
  
  function setDate(passedDate, sendToObj)
  {
	//var obj = eval ("document.forms[0]." + sendToObj);
	sendToObj.value = passedDate;
	closeDateWindow();   
  }
  


















function buildselectbox(fieldtype,count) {
	var output = '';	
	switch (fieldtype) {
	case 'TEXT':
		output = '<select name=\'wherefieldoperator'+count+'\'>'
		output = output + '<option>=</option>'
		output = output + '<option>like</option></select>'
		break;
	case 'DROP':
		output = '<select name=\'wherefieldoperator'+count+'\'>'
		output = output + '<option>=</option>'
		output = output + '<option>in</option></select>'
		break;
	case 'NUMBER':
		output = '<select name=\'wherefieldoperator'+count+'\'>'
		output = output + '<option>=</option>'
		output = output + '<option>>=</option>'
		output = output + '<option><=</option>'
		output = output + '<option><</option>'
		output = output + '<option>></option>'
		break;
	case 'CURRENCY':
		output = '<select name=\'wherefieldoperator'+count+'\'>'
		output = output + '<option>=</option>'
		output = output + '<option>>=</option>'
		output = output + '<option><=</option>'
		output = output + '<option><</option>'
		output = output + '<option>></option>'
		break;
	case 'DATE':
		output = '<select name=\'wherefieldoperator'+count+'\'>'
		output = output + '<option>=</option>'
		output = output + '<option>>=</option>'
		output = output + '<option><=</option>'
		output = output + '<option><</option>'
		output = output + '<option>></option>'
		break;
	default:
		output = '<select name=\'wherefieldoperator'+count+'\'>'
		output = output + '<option>=</option>'
		output = output + '<option>like</option></select>'
		break;
	}
	return output;
}

function addrow() {

		//if (document.all.criteriaTable.rows.length < 8) {
		if (document.all.criteriaTable.rows.length < 8) {
			var r  = document.createElement('tr');
			var ca = document.createElement('td');
			var cb = document.createElement('td');
			var cc = document.createElement('td');
			var cd = document.createElement('td');
			var t  = document.getElementById('criteriaTable');
			var tmpLabel = document.all.fieldname.options[document.all.fieldname.selectedIndex].text
			tmpLabel = tmpLabel + '<input type=\'hidden\' name=\'wherefieldname'+document.all.criteriaTable.rows.length + '\''
			tmpLabel = tmpLabel + ' value=\''+ eval(document.all.fieldname.value) + '\'>'
			if (document.all.fieldname.options[document.all.fieldname.selectedIndex].value2 == 'DROP') {
				var listvalues = document.all.fieldname.options[document.all.fieldname.selectedIndex].value3.split('<end>')
				var tmpField = '<select multiple size=\'3\' name=\'wherefieldvalue'+document.all.criteriaTable.rows.length + '\'>'
				for (i=0;i<listvalues.length;i++)
				tmpField = tmpField + '<option>' + listvalues[i] + '</option>'
				tmpField = tmpField + '</select>'
			} else {
				var tmpField = '<input type=\'text\' name=\'wherefieldvalue'+document.all.criteriaTable.rows.length + '\'>'
			}
			ca.innerHTML = tmpLabel
			cb.innerHTML = buildselectbox(document.all.fieldname.options[document.all.fieldname.selectedIndex].value2, document.all.criteriaTable.rows.length)
			cc.innerHTML = tmpField
			cd.innerHTML = '<input type=button value=\'Remove\' onclick=\'removeRow(this.parentNode.parentNode.rowIndex);\'>'
			r.appendChild(cd);
			r.appendChild(ca);
			r.appendChild(cb);
			r.appendChild(cc);
			t.tBodies(0).appendChild(r);
		} else {
			alert('Unable to add more fields to criteria.')
		}

}

function removeRow(index) {
	var tbl = eval('document.all.criteriaTable')
	if (!(tbl)) {
		var tbl = eval('document.all.tblcustom')
		tbl.all.cnt.value = parseInt(tbl.all.cnt.value) - 1;
	}
	if (tbl.rows.length-1 == index) {
		tbl.deleteRow(index)
	} else {
		alert('Please remove the last row first.')
	}
}

function addrowsorting() {
		if (document.all.sortingTable.rows.length < 8) {
			var r  = document.createElement('tr');
			var ca = document.createElement('td');
			var cb = document.createElement('td');
			var cd = document.createElement('td');
			var t  = document.getElementById('sortingTable');
			var tmpLabel = document.all.fieldname.options[document.all.fieldname.selectedIndex].text
			tmpLabel = tmpLabel + '<input type=\'hidden\' name=\'sortfieldname'+document.all.sortingTable.rows.length + '\''
			tmpLabel = tmpLabel + ' value=\''+ eval(document.all.fieldname.value) + '\'>'
			ca.innerHTML = tmpLabel
			cb.innerHTML = '<select name=\'sortfieldoperator'+document.all.sortingTable.rows.length+'\'><option value=\'ASC\'>Ascending</option><option value=\'DESC\'>Descending</option></select>'
			cd.innerHTML = '<input type=button value=\'Remove\'>'
			r.appendChild(cd);
			r.appendChild(ca);
			r.appendChild(cb);
			t.tBodies(0).appendChild(r);
		} else {
			alert('Unable to add more fields to sorting.')
		}
}

function XLExport(tableID) {
var i;
var j;
var mycell;
var objXL = new ActiveXObject("Excel.Application");
var objWB = objXL.Workbooks.Add();
var objWS = objWB.ActiveSheet;

for (i=0; i < document.getElementById(tableID).rows.length; i++) {
	for (j=0; j < document.getElementById(tableID).rows(i).cells.length; j++) {
		mycell = document.getElementById(tableID).rows(i).cells(j)
		objWS.Cells(i+1,j+1).Value = mycell.innerText;

//Format dates
		if ((mycell.innerText.indexOf("/") >= 0) && (mycell.innerText.length <= 10))
		{
			objWS.Cells(i+1,j+1).NumberFormat = "mm/dd/yy";
			objWS.Cells(i+1,j+1).HorizontalAlignment = -4108;
		}
	}
}
//objWS.Range("A1", "L1").Font.Bold = true;

objWS.Range("A1", "Z1").EntireColumn.AutoFit();

//objWS.Range("C1", "C1").ColumnWidth = 50;
objXL.Visible = true;
}