//呼叫資料庫資料
function loadXmlData2() {
	var xmlfile = 'comment.xml.php';
	var pageNum_Recordset2 = document.getElementById("pageNum_Recordset2");
      downloadUrl(xmlfile+"?pageNum_Recordset2="+pageNum_Recordset2.value, function(data) {
		  var pagecontrol2 = document.getElementById("pagecontrol2");
          var comment = data.documentElement.getElementsByTagName("comment");//獲取comment節點
          var startrecord2 = parseInt(comment[0].getAttribute("startRow_Recordset1"))+1;
          var endrecord2 = 0;
          if((parseInt(comment[0].getAttribute("startRow_Recordset1"))+parseInt(comment[0].getAttribute("maxRows_Recordset1")))<(parseInt(comment[0].getAttribute("totalRows_Recordset1")))){
          	  endrecord2 = parseInt(comment[0].getAttribute("startRow_Recordset1"))+parseInt(comment[0].getAttribute("maxRows_Recordset1"));
          	  tourist = tourist + '<img src="images/Next.gif" border=0> <img src="images/Last.gif" border=0>';
          }else{
          	  endrecord2 = parseInt(comment[0].getAttribute("totalRows_Recordset1"));
          }
          var tourist1 = "The "+startrecord2+" ～ "+endrecord2+" Records，Total "+comment[0].getAttribute("totalRows_Recordset1")+" Records<br>";
          var tourist2 = "The "+(parseInt(comment[0].getAttribute("pageNum_Recordset2"))+1)+" Page，Total "+(parseInt(comment[0].getAttribute("totalPages_Recordset1"))+1)+" Page";
          if(parseInt(comment[0].getAttribute("pageNum_Recordset2"))>0){
          	tourist2 = '<img src="images/First.gif" border=0 style="cursor: pointer" onClick="pageNum_Recordset2.value=0;loadXmlData2();"> <img src="images/Previous.gif" border=0 style="cursor: pointer" onClick="pageNum_Recordset2.value='+(parseInt(comment[0].getAttribute("pageNum_Recordset2"))-1)+';loadXmlData2();">' + tourist2;
          }
          if((parseInt(comment[0].getAttribute("startRow_Recordset1"))+parseInt(comment[0].getAttribute("maxRows_Recordset1")))<(parseInt(comment[0].getAttribute("totalRows_Recordset1")))){
          	  tourist2 = tourist2 + '<img src="images/Next.gif" border=0 style="cursor: pointer" onClick="pageNum_Recordset2.value='+(parseInt(comment[0].getAttribute("pageNum_Recordset2"))+1)+';loadXmlData2();"> <img src="images/Last.gif" border=0 style="cursor: pointer" onClick="pageNum_Recordset2.value='+parseInt(comment[0].getAttribute("totalPages_Recordset1"))+';loadXmlData2();">';
          }
          var tourist = tourist1 + tourist2
          pagecontrol2.innerHTML = tourist;
          // 處理每一個comment節點
          cleardatasheet2();
          for (var i = 1; i < comment.length; i++) {
            addComments(comment[i],i);
          }
        $(document).ready(function(){
				$("a[rel^='prettyPhoto']").prettyPhoto();
		});

      });
}

//載入Comment紀錄
function addComments(node,j) {
	var CommentDate = node.getAttribute("comment_update");
	var resight_sn = node.getAttribute("resight_sn");
	var resight_date = node.getAttribute("resight_date");
	var comment_user = node.getAttribute("comment_user");
	var comment_content = node.getAttribute("comment_content");
	var location = node.getAttribute("location");
	var birdname = node.getAttribute("birdname");
	var region = node.getAttribute("region");
        
    //插入紀錄表
	var Table = document.getElementById("comment");
	var j=Table.rows.length;
	Cell = new Array(7);
	Cell[0] = "<a href='details.php?resightsn="+resight_sn+"' target='_blank'>"+resight_sn+"</a>";
	Cell[1] = '<font face="Arial">'+birdname+'</font>';
	Cell[2] = '<font face="Arial">'+resight_date+'</font><br>';
	Cell[3] = '<iframe src="bands.php?resightsn='+resight_sn+'" height="90" width="85" scrolling="no" frameborder="0" ></iframe>';
	Cell[4] = region;
	Cell[5] = location;
	Cell[6] = '<div align="left">'+comment_content+'</div><div align="right"><i>by </i><b><font color="blue">'+comment_user+'</font></b> on '+CommentDate+'</div>';
	
	newRow = Table.insertRow(-1);
	newRow.setAttribute("align","center");
	for(var k=0;k<7;k++){
		newcell = newRow.insertCell(-1);
		newcell.innerHTML = Cell[k];
		if((k==0)){newcell.setAttribute("nowrap",true);}
		if((k==4)){newcell.setAttribute("align",'center');}
	}
}

function cleardatasheet2(){
	var Table = document.getElementById("comment");
	var j=Table.rows.length;
	for(var i=0;i<j;i++){
		Table.deleteRow(0);
	}
	Cell = new Array(7);
	Cell[0] = "SN";
	Cell[1] = "Species";
	Cell[2] = "Date";
	Cell[3] = "Mark";
	Cell[4] = "Region";
	Cell[5] = "Location";
	Cell[6] = "Comments";
	newRow = Table.insertRow(-1);
	newRow.setAttribute("align","center");
	for(var k=0;k<7;k++){
		newcell = newRow.insertCell(-1);
        if((k==1)||(k==2)){
        	newcell.setAttribute("nowrap",true);
        }
		newcell.innerHTML = Cell[k];
	}
}

/**匯入xml檔
* Returns an XMLHttp instance to use for asynchronous
* downloading. This method will never throw an exception, but will
* return NULL if the browser does not support XmlHttp for any reason.
* @return {XMLHttpRequest|Null}
*/
function createXmlHttpRequest() {
 try {
   if (typeof ActiveXObject != 'undefined') {
     return new ActiveXObject('Microsoft.XMLHTTP');
   } else if (window["XMLHttpRequest"]) {
     return new XMLHttpRequest();
   }
 } catch (e) {
   changeStatus(e);
 }
 return null;
};

/**匯入xml函式
* This functions wraps XMLHttpRequest open/send function.
* It lets you specify a URL and will call the callback if
* it gets a status code of 200.
* @param {String} url The URL to retrieve
* @param {Function} callback The function to call once retrieved.
*/
function downloadUrl(url, callback) {
 var status = -1;
 var request = createXmlHttpRequest();
 if (!request) {
   return false;
 }

 request.onreadystatechange = function() {
   //if (request.readyState == 4) {//有些瀏覽器没有readyState属性
     try {
       status = request.status;
     } catch (e) {
       // Usually indicates request timed out in FF.
     }
     if (status == 200) {
       callback(request.responseXML, request.status);
       request.onreadystatechange = function() {};
     }
   //}
 }
 request.open('GET', url, true);
 try {
   request.send(null);
 } catch (e) {
   changeStatus(e);
 }
};

/**
 * Parses the given XML string and returns the parsed document in a
 * DOM data structure. This function will return an empty DOM node if
 * XML parsing is not supported in this browser.
 * @param {string} str XML string.
 * @return {Element|Document} DOM.
 */
function xmlParse(str) {
  if (typeof ActiveXObject != 'undefined' && typeof GetObject != 'undefined') {
    var doc = new ActiveXObject('Microsoft.XMLDOM');
    doc.loadXML(str);
    return doc;
  }

  if (typeof DOMParser != 'undefined') {
    return (new DOMParser()).parseFromString(str, 'text/xml');
  }

  return createElement('div', null);
}

/**
 * Appends a JavaScript file to the page.
 * @param {string} url
 */
function downloadScript(url) {
  var script = document.createElement('script');
  script.src = url;
  document.body.appendChild(script);
}