var xmlHttp = createXmlHttpRequestObject();
var curImg; //used to display room map highlights

//######################## used Member Info search #########################
function searchDB() {
  if (xmlHttp)
  {
    try
	{
      myDiv = document.getElementById("dbresults");
      myDiv.innerHTML = "Searching Database...";
	  var scln = document.getElementById("lastname").value;
	  if (scln.length > 0) {
	    xmlHttp.open("GET",  "includes/loadmembers.php?ln=" + scln + "&fn=" + document.getElementById("firstname").value, true);
	    xmlHttp.onreadystatechange = handleRequestStateChange;
	    xmlHttp.send(null);
	  } else {
	    alert("Last Name criteria must contain at least one character.");
	  }
	}
	catch (e)
	{
	  alert("Can't connect to server:\n" + e.toString());
	}
  }
}

function createXmlHttpRequestObject() 
{  
  // will store the reference to the XMLHttpRequest object
  var xmlHttp;
  // if running Internet Explorer
  if(window.ActiveXObject)
  {
    try
    {
      xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
    }
    catch (e) 
    {
      xmlHttp = false;
    }
  }
  // if running Mozilla or other browsers
  else
  {
    try 
    {
      xmlHttp = new XMLHttpRequest();
    }
    catch (e) 
    {
      xmlHttp = false;
    }
  }
  // return the created object or display an error message
  if (!xmlHttp)


    alert("Error creating the XMLHttpRequest object.");
  else 
    return xmlHttp;
}

function createXmlHttpRequestObjectOld()
{
  var xmlHttp;
  try
  {
	xmlHttp = new XMLHttpRequest();
  }
  catch (e)
  {
	var XmlHttpVersions = new Array('MSXML2.XMLHTTP.6.0',
									'MSXML2.XMLHTTP.5.0',
									'MSXML2.XMLHTTP.4.0',
									'MSXML2.XMLHTTP.3.0',
									'MSXML2.XMLHTTP',
									'Microsoft.XMLHTTP');
	for (var i=0; i<XmlHttpVersions.length && !xmlHttp; i++)
	{
	  try
	  {
		xmlHttp = new ActiveObject(XmlHttpVersions[i]);
	  }
	  catch (e) {}
	}
  }
  if (!xmlHttp)
	alert("Error creating the XMLHttpRequest object.");
  else
    return xmlHttp;
}

function handleRequestStateChange()
{
  myDiv = document.getElementById("dbresults");
  if (xmlHttp.readyState == 4)
  {
    if (xmlHttp.status == 200)
	{
	  try
	  {
	    var data = xmlHttp.responseText;
		eval(data);
		if (members.length > 0) {
  		  myDiv.innerHTML = "<b>" + members.length + " records match search criteria.</b><br /><br />";

		  var t = document.createElement('table');
		  t.id ="dbtable";
		  var tb = document.createElement('tbody');
				
		  for(m in members)
		  {
 		    var tr = document.createElement('tr');
		    var td0 = document.createElement('td');
		    td0.width = "90px";
		    td0.className = "boldtext";
		    var txt0 = document.createTextNode(members[m].ln);
		    td0.appendChild(txt0);
		    tr.appendChild(td0)

		    var td1 = document.createElement('td');
		    td1.width = "180px";
		    var txt1 = document.createTextNode(members[m].fn);
		    td1.appendChild(txt1);
		    tr.appendChild(td1)

		    var td2 = document.createElement('td');
		    td2.width = "210px";
		    var txt2 = document.createTextNode(members[m].ad);
		    td2.appendChild(txt2);
		    tr.appendChild(td2)

		    var td3 = document.createElement('td');
		    td3.width = "90px";
		    var txt3 = document.createTextNode(members[m].cy);
		    td3.appendChild(txt3);
		    tr.appendChild(td3)

		    var td4 = document.createElement('td');
		    td4.width = "20px";
		    var txt4 = document.createTextNode(members[m].st);
		    td4.appendChild(txt4);
		    tr.appendChild(td4)

		    var td5 = document.createElement('td');
		    td5.width = "90px";
		    var txt5 = document.createTextNode(members[m].zp);
		    td5.appendChild(txt5);
		    tr.appendChild(td5)

		    var td6 = document.createElement('td');
		    td6.width = "90px";
		    var txt6 = document.createTextNode(members[m].hp);
		    td6.appendChild(txt6);
		    tr.appendChild(td6)

		    tb.appendChild(tr);
		  }
		  t.appendChild(tb);
		  myDiv.appendChild(t);
		} else {
  		  myDiv.innerHTML = "<b>No records match search criteria.</b><br /><br />";
		}
	    }
	    catch (e)
	    {
	      alert("Error reading the response: " + e.toString());
	    }
	  }
	  else
	  {
	    alert("There was a problem retrieving the data:\n" + xmlHttp.statusText);
	} //end of status
  } //end of readystate
} //end of function

//######################## used with Student Page #########################
function studentcalendar() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = '<div align="center" style="padding:15px;"><iframe src="http://www.google.com/calendar/embed?bgcolor=%23f0f0d0&src=youthtwbc%40gmail.com&ctz=America/Chicago" style="border: 0" width="800" height="560" frameborder="0" scrolling="no"></iframe></div>';
}

function serviceprojects() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = "Service Projects";
}

function photogallery() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = "Photo Gallery";
}

function studentleaders() {
    meDiv = document.getElementById("bigright");
	strdata = '<br /><div align="center"><h2>Youth Council</div></h2>';
	strdata += '<table border="0" align="center" summary="">';
	strdata += '<tr><td class="students">Holly Hawbaker</td><td class="students">Jana Kahler</td><td class="students">Claire Newberry</td></tr>';
	strdata += '<tr><td class="students">Tayler Newberry</td><td class="students">Dane Peacock</td><td class="students">Ashley Sisemore</td></tr>';
	strdata += '<tr><td class="students">&nbsp;</td><td class="students">Layton Sisemore</td><td class="students">&nbsp;</td></tr></table>';
	strdata += '<br /><br /><div align="center"><h2>Youth Committee</div></h2>';
	strdata += '<table border="0" align="center" summary="">';
	strdata += '<tr><td class="students">Kyle Lindsey, Chair</td><td class="students">Beth Franklin, Vice Chair</td><td class="students">Kara Newberry, Secretary</td></tr>';
	strdata += '<tr><td class="students">Gwen Flake</td><td class="students">Jamie Hawbaker</td><td class="students">Susan Harris</td></tr>';
	strdata += '<tr><td class="students">Jerry Kahler</td><td class="students">Brandon Smith</td><td class="students">Brian Watts</td></tr></table>';
	strdata += '<br /><br /><div align="center"><h2>Bible Study Teachers</div></h2>';
	strdata += '<table border="0" align="center" summary="">';
	strdata += '<tr><td class="students">Student Minister</td><td class="students">High School Class</td><td class="students">Middle School Class</td></tr>';
	strdata += '<tr><td class="students">Cory Pepiton</td><td class="students">John & Beth Franklin</td><td class="students">Kyle & Wendy Lindsey</td></tr>';
	strdata += '<tr><td class="students">&nbsp;</td><td class="students">Brandon & Brandy Smith<br />"God Provides" - Sun Evenings</td><td class="students">&nbsp;</td></tr></table>';
	meDiv.innerHTML = strdata;
}

function churchcalendar() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = '<div align="center" style="padding:15px;"><iframe src="http://www.google.com/calendar/embed?bgcolor=%23f0f0d0&src=twbccalendarshare%40gmail.com&ctz=America/Chicago" style="border: 0" width="800" height="560" frameborder="0" scrolling="no"></iframe></div>';
}

function mediacalendar() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = '<div align="center" style="padding:15px;"><iframe src="http://www.google.com/calendar/embed?bgcolor=%23f0f0d0&mode=WEEK&src=lptcu0n88lcdhvicjpuiijm5vc%40group.calendar.google.com&ctz=America/Chicago" style="border: 0" width="800" height="560" frameborder="0" scrolling="no"></iframe></div>';

}

function securitycalendar() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = '<div align="center" style="padding:15px;"><iframe src="http://spreadsheets.google.com/pub?key=trSB0Q0H16hNKfhQM9jjLVA&output=html" style="border: 0" width="800" height="560" frameborder="0" scrolling="no"></iframe></div>';
}

//###################### used with SS class map #######################
function roomshow(rn) {
	//turns on display of map for room number
	myImg = document.getElementById("r" + rn);
	myImg.className = "show";
	curImg = myImg;
}

function rxxxhide() {
	//turns off display of map for most recent room number displayed
	curImg.className = "hide";
}
//#####################################################################

function oaxaca() {
    meDiv = document.getElementById("dbresults");
	meDiv.innerHTML = '<div class="normaltext">';
	meDiv.innerHTML += '<div align="center"><h2>Oaxaca, Mexico Mission Trip 2011</h2><div style="width: 625px; text-align: left;">The Woods Baptist is returning to Oaxaca, Mexico in July 2011 in association with Buckner International. A team of forty people from The Woods spent a week in Oaxaca in July 2010 leading Vacation Bible Schools, providing medical services, haircuts, hygiene classes, and working on several construction projects including work on a community park. The cost for the trip is approximately $1000 and a commitment must be made by late February. You can be involved in this mission endeavor by going, by giving, by sending, and by praying.</div></div>';
	meDiv.innerHTML += '<h2>About Oaxaca</h2>Oaxaca has 570 municipaliities.<br /><br />Almost 40% of the population is under 14 years old.<br /><br /> Only 5.6% of the population gets past the sixth grade.';
	meDiv.innerHTML += '<br /><br .?One third of the people do not have running water.<b></b>About 58% do not have plumbing and about 12% does not have electricity. ';
	meDiv.innerHTML += '<br /><br /><b>The fields are white unto harvest!</b><br /><br /><br /><u>Related Links</u><br /><br /><a href="http://www.buckner.org" target="_blank">Bucker International</a>';
	meDiv.innerHTML += '<br /><br /><a href="http://www.oaxaca-travel.com/guide/index.php?lang=us" target="_blank">Oaxaca Travel Guide</a>';

	meDiv.innerHTML += '</div';
}

function clearpanel() {
    meDiv = document.getElementById("dbresults");
	meDiv.innerHTML = '';
}

function inourlibrary() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = "Libray Content Search";
}

function deaconfamilies() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = "List/Search of Deacon Families";
}

function uploadphotos() {
    meDiv = document.getElementById("bigright");
	meDiv.innerHTML = "Allow members to upload photos of church events for posting on the web.";
}

function tylermissions() {
  if (xmlHttp)
  {
    try
	{
      myDiv = document.getElementById("dbresults");
      myDiv.innerHTML = "<br />loading Tyler Area Missions...";
	    xmlHttp.open("GET",  "./loadTLMissions.php", true);
	    xmlHttp.onreadystatechange = handleRequestStateChangeTL;
	    xmlHttp.send(null);
	}
	catch (e)
	{
	  alert("Can't connect to server:\n" + e.toString());
	}
  }
}

function handleRequestStateChangeTL()
{
  myDiv = document.getElementById("dbresults");
  if (xmlHttp.readyState == 4)
  {
    if (xmlHttp.status == 200)
	{
	  try
	  {
	    var data = xmlHttp.responseText;
		eval(data);
		if (tl.length > 0) {
  		  myDiv.innerHTML = "<br />";

		  var t = document.createElement('table');
		  t.id ="dbtable";
		  var tb = document.createElement('tbody');
				
 		  //headers
		    var tr = document.createElement('tr');
		    var td0 = document.createElement('td');
		    td0.width = "275px";
		    td0.className = "boldtext";
		    var txt0 = document.createTextNode("Mission Organization");
		    td0.appendChild(txt0);
		    tr.appendChild(td0)

		    var td1 = document.createElement('td');
		    td1.width = "200px";
		    td1.className = "boldtext";
		    var txt1 = document.createTextNode("Address");
		    td1.appendChild(txt1);
		    tr.appendChild(td1)

		    var td2 = document.createElement('td');
		    td2.width = "90px";
		    td2.className = "boldtext";
		    var txt2 = document.createTextNode("City/Zip");
		    td2.appendChild(txt2);
		    tr.appendChild(td2)

		    var td3 = document.createElement('td');
		    td3.width = "100px";
		    td3.className = "boldtext";
		    var txt3 = document.createTextNode("Phone");
		    td3.appendChild(txt3);
		    tr.appendChild(td3)

		    var td4 = document.createElement('td');
		    td4.width = "175px";
		    td4.className = "boldtext";
		    var txt4 = document.createTextNode("Contact");
		    td4.appendChild(txt4);
		    tr.appendChild(td4)

		    tb.appendChild(tr);

		  //entries from database
		  for(m in tl)
		  {
 		    var tr = document.createElement('tr');
		    var td0 = document.createElement('td');
		    td0.width = "275px";
		    td0.className = "dbtext";
			if (tl[m].lnk.length > 0) {
			  var aElem = document.createElement('a');
        	  aElem.href = 'http://' + tl[m].lnk;
		      aElem.target = '_blank';
			  var txt0 = document.createTextNode(tl[m].nm);
	          aElem.appendChild(txt0);
		      td0.appendChild(aElem);
			} else {
		      var txt0 = document.createTextNode(tl[m].nm);
		      td0.appendChild(txt0);
			}
		    tr.appendChild(td0)

		    var td1 = document.createElement('td');
		    td1.width = "200px";
		    td1.className = "dbtext";
		    var txt1 = document.createTextNode(tl[m].ad);
		    td1.appendChild(txt1);
		    tr.appendChild(td1)

		    var td2 = document.createElement('td');
		    td2.width = "90px";
		    td2.className = "dbtext";
		    var txt2 = document.createTextNode(tl[m].cz);
		    td2.appendChild(txt2);
		    tr.appendChild(td2)

		    var td3 = document.createElement('td');
		    td3.width = "100px";
		    td3.className = "dbtext";
		    var txt3 = document.createTextNode(tl[m].pn);
		    td3.appendChild(txt3);
		    tr.appendChild(td3)

		    var td4 = document.createElement('td');
		    td4.width = "175px";
		    td4.className = "dbtext";
		    var txt4 = document.createTextNode(tl[m].cn);
		    td4.appendChild(txt4);
		    tr.appendChild(td4)

		    tb.appendChild(tr);
		  }
		  t.appendChild(tb);
		  myDiv.appendChild(t);
		} else {
  		  myDiv.innerHTML = "<b>Could not load data at this time.</b><br /><br />";
		}
	    }
	    catch (e)
	    {
	      alert("Error reading the response: " + e.toString());
	    }
	  }
	  else
	  {
	    alert("There was a problem retrieving the data:\n" + xmlHttp.statusText);
	} //end of status
  } //end of readystate
} //end of function