function mysqlDateAddLeadingZeros(date){  //mysql formatted time a makes sure the columns all have two digits and 4 for the year
	var newFirst=date.split(" ")[0];
	var newYear=newFirst.split("-")[0];
	var newMonth=newFirst.split("-")[1];
	var newDate=newFirst.split("-")[2];
	var newSecond=date.split(" ")[1];
	var newHours=newSecond.split(":")[0];
	var newMinutes=newSecond.split(":")[1];
	var newSeconds=newSecond.split(":")[2];
	if(newMonth.length<2)newMonth="0"+newMonth;
	if(newDate.length<2)newDate="0"+newDate;
	if(newHours.length<2)newHours="0"+newHours;
	if(newMinutes.length<2)newMinutes="0"+newMinutes;
	if(newSeconds.length<2)newSeconds="0"+newSeconds;
	return newYear + "-" + newMonth + "-" + newDate + " " + newHours + ":" + newMinutes + ":" + newSeconds;
	
}
function validateDate(fld) {
	if(fld.value.length>0){
		 var RegExPattern = /^(?=\d)(?:(?:(?:(?:(?:0?[13578]|1[02])(\/|-|\.)31)\1|(?:(?:0?[1,3-9]|1[0-2])(\/|-|\.)(?:29|30)\2))(?:(?:1[6-9]|[2-9]\d)?\d{2})|(?:0?2(\/|-|\.)29\3(?:(?:(?:1[6-9]|[2-9]\d)?(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|[2468][048]|[3579][26])00))))|(?:(?:0?[1-9])|(?:1[0-2]))(\/|-|\.)(?:0?[1-9]|1\d|2[0-8])\4(?:(?:1[6-9]|[2-9]\d)?\d{2}))($|\ (?=\d)))?(((0?[1-9]|1[012])(:[0-5]\d){0,2}(\ [AP]M))|([01]\d|2[0-3])(:[0-5]\d){1,2})?$/;
	
		var errorMessage = 'Please enter valid date in the following format:\nmm/dd/yyyy';
		if ((fld.value.match(RegExPattern)) && (fld.value!='')) {
		   
		} else {
			alert(errorMessage);
			fld.focus();
		}
	}
}
function getStyle(obj,cAttribute){ 
	if (obj.currentstyle){ //if IE 
		var curVal=eval('obj.currentstyle.'+cAttribute) 
	}else{ //if Mozilla/FF 
		var curVal=eval('document.defaultView.getComputedStyle(obj, null).'+cAttribute) 
	} 
	return curVal;
	//alert('style attribute '+cAttribute+' = ' + curVal) 
} 

function fix_cookies(cookie){
	var message="";
	message=cookie.replace(/\+/g," ");
	message=message.replace(/%2C/g,",");
	message=message.replace(/%23/g,"#");
	message=message.replace(/%21/g,"!");
	message=message.replace(/%40/g,"@");
	message=message.replace(/%3F/g,"?");
	message=message.replace(/%0D%0A/g,"<br>");
	message=message.replace(/%27/g,"'");
	message=message.replace(/%26/g,"&");
	message=message.replace(/%5Cn/g,"<br>");
	message=message.replace(/%7C/g,"|");
	message=message.replace(/%3A/g,":");
	message=message.replace(/%3B/g,";");
	message=message.replace(/%5C/g,"\\");
	message=message.replace(/%2F/g,"/");
	message=message.replace(/%20/g," ");
	message=message.replace(/%28/g,"(");
	message=message.replace(/%29/g,")");
	message=message.replace(/%24/g,"$");
	message=message.replace(/%22/g,"\"");
	message=message.replace(/%3C/g,"<");
	message=message.replace(/%3E/g,">");
	message=message.replace(/%3D/g,"=");
	message=message.replace(/%0A/g,"");
	message=message.replace(/%92/g,"'");
	
	
	return message;
}
function validate_email(fld){
	if(fld.value.length>0){
		reg = /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/
		var newarray=fld.value.split(";"); //check to see if its multiple or just one
		if(newarray.length>1){  //there was more than one address
			for(x=0;x<newarray.length;x++){
				var testvalue=trim(newarray[x]);
				if(testvalue.length>0){
					if(reg.test(testvalue)){  //it passed
					}else{
						alert("Invalid format... n\n" + testvalue + "\n\nPlease enter a valid format\nor clear the entry...");
						setTimeout(function(){fld.focus()}, 10);
						fld.select();
						return false;
					}
				}
			}
			//if it made it here it's ok
			return true;
		}
		//if it made it here it's a single address
		if(reg.test(fld.value)){
				return true;
		}
		alert('Invalid format on e-mail address..\n\n' + fld.value + "\n\nPlease enter a valid format\nor clear the entry...");
		
		setTimeout(function(){fld.focus()}, 10);

		//fld.focus();
		fld.select();
		return false;

	}
}
function cap_first_letter(fld){
	//newname_array[1]=newname_array[1].substr(1,newname_array[1].length);
	var word="";
	word=fld.value.substr(0,1).toUpperCase() + fld.value.substr(1,fld.value.length);
	fld.value=word;
}
/*
function compare_start_end(date1,date2,control){
	if(date1)&&(date2){
		if(date1>date2){
			var errorMessage = 'The Stop Showing Date must the same or later than the Start Showing Date';
			alert(errorMessage);
        	control.focus();
		}
	}
}
*/
function validate_phone(fld){
	if(fld.value.length>0){
		var newnum = fld.value.replace(/[^\d]/g,'');
		if (newnum.length == 10) {
			newnum = newnum.substring(0,3) + " " + newnum.substring(3,6) + "-" + newnum.substring(6,10)
			fld.value = newnum;
			return true;
		}
		if(newnum.length==7){
			alert('Please include an Area Code in the Phone Number..');
		}else{
			alert('Please enter a valid Phone Number\nor clear the entry..');
		}
		setTimeout(function(){fld.focus()}, 10);
		fld.select();
		return false;
	}
}
function validateNumbers(fld){
	
	if(fld.value.length>0){
		reg = /^\d*\.{0,1}\d+$/;
		if(reg.test(fld.value)){
				return true;
		}
		alert('Invalid number..\n\n' + fld.value + '\n\nPlease enter numbers or decimals only');
		
		setTimeout(function(){fld.focus()}, 10);

		//fld.focus();
		fld.value='';
		fld.select();
		return false;

	}
}
function validateIntPosNeg(fld){
	
	if(fld.value.length>0){
		reg=/^-{0,1}\d*\.{0,1}\d+$/;
		if(reg.test(fld.value)){
				return true;
		}
		alert('Invalid number..\n\n' + fld.value + '\n\nPlease enter numbers or decimals only');
		
		setTimeout(function(){fld.focus()}, 10);

		//fld.focus();
		fld.value='';
		fld.select();
		return false;

	}
}
function numbers_only(fld){
	var newnum = fld.value.replace(/[^\d]/g,'');
	return newnum;
}
function trim(str)
{
   return str.replace(/^\s*|\s*$/g,"");
}
function reverseaname(name){
	var newname_array=name.split(",");
	var newname="";
	if(newname_array.length>1){
		newname_array[1]=newname_array[1].substr(1,newname_array[1].length);   //get rid of the leading space
		newname=newname_array[1] + " " + newname_array[0];
		return newname;
	}else{  //there's no comma
		return name;
	}
}
function firstnameonly(name){
	var newname_array=name.split(",");
	var newname="";
	if(newname_array.length>1){
		newname_array[1]=newname_array[1].substr(1,newname_array[1].length);   //get rid of the leading space
		newname=newname_array[1];
		return newname;
	}else{  //there's no comma
		return name;
	}
}
function lastnameonly(name){  //excludes the comma
	var newname_array=name.split(",");
	if(newname_array.length>1){
		newname_array[0]=newname_array[0].substr(0,newname_array[1].length);   //get rid of the leading space
		return newname_array[0];
	}else{  //there's no comma
		return name;
	}
}
//===========================================================================================================================
//the following function pulls values from the url as in php $_GET  you have to know the variable name to use this function
function get_url_value(varname)
{
  // First, we load the URL into a variable
  var url = window.location.href;

  // Next, split the url by the ?
  var qparts = url.split("?");

  // Check that there is a querystring, return "" if not
  if (qparts.length == 0)
  {
    return "";
  }

  // Then find the querystring, everything after the ?
  var query = qparts[1];

  // Split the query string into variables (separates by &s)
  var vars = query.split("&");

  // Initialize the value with "" as default
  var value = "";

  // Iterate through vars, checking each one for varname
  for (i=0;i<vars.length;i++)
  {
    // Split the variable by =, which splits name and value
    var parts = vars[i].split("=");
    
    // Check if the correct variable
    if (parts[0] == varname)
    {
      // Load value into variable
      value = parts[1];

      // End the loop
      break;
    }
  }
  
  // Convert escape code
  value = unescape(value);

  // Convert "+"s to " "s
  value.replace(/\+/g," ");

  // Return the value
  return value;
}
//END OF GET VALUE FROM URL FUNCTION ===========================================================================
function getURLParam(strParamName){
  var strReturn = "";
  var strHref = window.location.href;
  if ( strHref.indexOf("?") > -1 ){
    //var strQueryString = strHref.substr(strHref.indexOf("?")).toLowerCase();
	var strQueryString = strHref.substr(strHref.indexOf("?"));
    var aQueryString = strQueryString.split("&");
    for ( var iParam = 0; iParam < aQueryString.length; iParam++ ){
      if ( aQueryString[iParam].indexOf(strParamName + "=") > -1 ){
        var aParam = aQueryString[iParam].split("=");
        strReturn = aParam[1];
        break;
      }
    }
  }
  return strReturn;
} 
function addZero(vNumber){ 
  return ((vNumber < 10) ? "0" : "") + vNumber 
} 
function stripLeftZero(vText){
	return vText.substr(0,1)=="0"?vText.substr(1,vText.length-1):vText;
}
function formatDate(vDate, vFormat){ 
  var vDay                      = addZero(vDate.getDate()); 
  var vMonth            = addZero(vDate.getMonth()+1); 
  var vYearLong         = addZero(vDate.getFullYear()); 
  var vYearShort        = addZero(vDate.getFullYear().toString().substring(3,4)); 
  var vYear             = (vFormat.indexOf("yyyy")>-1?vYearLong:vYearShort) 
  var vHour             = addZero(vDate.getHours()); 
  var vMinute           = addZero(vDate.getMinutes()); 
  var vSecond           = addZero(vDate.getSeconds()); 
  var vDateString       = vFormat.replace(/dd/g, vDay).replace(/MM/g, vMonth).replace(/y{1,4}/g, vYear) 
  vDateString           = vDateString.replace(/hh/g, vHour).replace(/mm/g, vMinute).replace(/ss/g, vSecond) 
  return vDateString 
}
function mysql_date_to_ampm(newTime){  //returns 12 hour format time from mysql database record
	var time1=newTime.split(" ");
	var time2=time1[1].split(":");
	var hours=time2[0];
	var ampm = "AM";
	//first check for midnight
	if(hours==24){
		hours=0;
		ampm="AM";
	}else if(hours>11){
		ampm="PM";
	}
	
	if(hours>12){
		hours-=12;
	}
	return hours + ":" + time2[1] + " " + ampm;
}
function ampmFrom24(newTime){ //returns an am/pm array from 24 hour time  hh:mm
	var time1=newTime.split(":");
	if(time1[0]>=12){
		time1[0]-=12;
		time1[2]="PM";
	}else{
		time1[2]="AM";
	}
	if(time1[0]==0)time1[0]=12;
	var newHours=time1[0].toString();
	var newMinutes=time1[1].toString();
	if(newHours.length==1)newHours="0"+newHours;
	if(newMinutes.length==1)newMinutes="0"+newMinutes;
	time1[0]=newHours;
	time1[1]=newMinutes;
	return time1;
}

function ampmTo24(newTime){ //just the opposite, returns 24 time hh:mm from hh:mm am/pm
	var time1=newTime.split(" ");
	var time2=time1[0].split(":");
	if(time1[1]=="PM"){
		time2[0]=parseFloat(time2[0])+12;
	}
	if(time2[0]==24)time2[0]=12;
	if(time2[0]==12&time1[1]=="AM")time2[0]=0;
	return time2[0]+":"+time2[1];
}
function standardDateToMYSQL(newDate){
		//takes 06/07/2008 to mysql... date MUST HAVE 2 digit month  2 digit date and 4 digit year
		var workDate=newDate.split("/");
		if(workDate[0].length==1)workDate[0]="0"+workDate[0];
		if(workDate[1].length==1)workDate[1]="0"+workDate[1];
		if(workDate[2].length==2)workDate[2]="20"+workDate[2];
		return workDate[2] + "-" + workDate[0] + "-" + workDate[1] + " 00:00:00";
}
function standardDateFromMYSQL(newDate){
		return newDate.substr(5,2) + "/" + newDate.substr(8,2) + "/" + newDate.substr(0,4);
		
}
function mysql_date_to_stringdate(newTime){ //returns the date  mm/dd/yyyy from mysql database record
	var time1=newTime.split(" ");
	var time2=time1[0].split("-");
	return time2[1] + "/" + time2[2] + "/" + time2[0];
}
function ampm_array(newTime){  //returns an array from 12hour format time - handy for populating select controls
	time1=newTime.split(":");
	time2=time1[1].split(" ");
	time3=new Array();
	time3[0]=time1[0]; //hours
	time3[1]=time2[0]; //minutes
	time3[2]=time2[1]; //ampm
	return time3;
}
function date_array(newTime){  //returns an array from date mm/dd/yyyy format (as above) - handy for populating select controls
	time1=newTime.split("/");
	//time[0] is month 1 is date   2 is year
	return time1;
}
function epochFromMySql(newTime){
	time1=newTime.split(' ');
	time2=time1[0].split('-');
	time3=time1[1].split(':');
	var d = new Date();
	d.setFullYear(time2[0]);

	d.setMonth(time2[1]-1);
	
	d.setDate(time2[2]);
	d.setHours(time3[0]);
	d.setMinutes(time3[1]);
	d.setSeconds(time3[2]);
	return d;
}
function setCookie(newItem,value){
	var date = new Date();
	date.setTime(date.getTime()+(300000000));
	var expires = '; expires='+date.toGMTString();
	document.cookie=newItem+'='+value+';expires='+expires+'; path=/';
}
function killCookie(newItem){
		var date = new Date();
		date.setTime(date.getTime()-(500));
		var expires = '; expires='+date.toGMTString();
		document.cookie=newItem+'= ;expires='+expires+'; path=/';
}
function returnToday(){  //returns current date in text as mm/dd/yyyy
	var today = new Date();
	var printToday= (today.getMonth()+1) + "/" + today.getDate() + "/" + today.getFullYear();
	return printToday;
}
function returnTime(){   //12 hour format
	var today = new Date();
	//first check for midnight
	hours=today.getHours();
	minutes=today.getMinutes();
	ampm="AM"; //by default
	if(hours==24){
		hours=0;
	}else if(hours>11){
		ampm="PM";
	}
	
	if(hours>12){
		hours-=12;
	}
	if(minutes<10)minutes= "0" + minutes;
	return hours + ":" + minutes + " " + ampm;
}

function printReport(orientation){
	if(orientation=='landscape'){
		alert("IMPORTANT!\n\nThis report must be printed Landscape.\n\nPlease set your printer preferences to Landscape\nwhen the printer menu pops up.");
	}
	window.print();
}
function addslashes(str) {
str=str.replace(/\'/g,'\\\'');
str=str.replace(/\"/g,'\\"');
str=str.replace(/\\/g,'\\\\');
str=str.replace(/\0/g,'\\0');
return str;
}
function stripslashes(str) {
str=str.replace(/\\'/g,'\'');
str=str.replace(/\\"/g,'"');
str=str.replace(/\\\\/g,'\\');
str=str.replace(/\\0/g,'\0');
return str;
}
function prepFileName(str){
		str=str.replace(/,/g,' ');
		return str;
}
function validateFileName(str){
   if (/^[^\\\/\:\*\?\"\<\>\|\.]+(\.[^\\\/\:\*\?\"\<\>\|\.]+)+$/.test(str)) {
      return true;
   }
   else {
      return false;
   }
}