// JavaScript Document
// Print function
 function doPrint()
           { 
                   var contentValue = document.getElementById("content").innerHTML;
                   var disp_setting ="toolbar=1,location=0,directories=0,menubar=0,"; 
                       disp_setting+="scrollbars=1,width=800,height=600,left=100,top=100"; 
                   var mywind       = open("","",disp_setting);

                   with(mywind.document)
                        {
                          open();
                     write("<html><body onLoad='self.print()'>");
					 write("<table width='800' border='0' align='center'><tr>")
           write("<td align='right'><img src='images/logo2.JPG' width='120' height='120'></td>");
			   write("<td align='center'>");
   			    write("<p>National Center for Faculty and <br/>");
			   write("   Leadership Development  <br/>");
               write("       NCFLD/IBCT </p></td>");      
           write("<td align='left'><img src='images/logo1.JPG' width='150' height='150'/></td>");
   					 write("</tr></table><br/>");
                     write(contentValue);
                     write("</body></html>");
                          close();
                        }
                        mywind.focus();

                 }				 
 function doPrint_()
       {
                   var contentValue = document.getElementById("content").innerHTML;
                   var disp_setting ="toolbar=1,location=0,directories=0,menubar=0,"; 
                       disp_setting+="scrollbars=1,width=800,height=600,left=100,top=100"; 
                   var mywind       = open("","",disp_setting);

                   with(mywind.document)
                        {
                          open();
                     write("<html><body onLoad='self.print()'>");
					 write("<table width='800' border='0' align='center'><tr>")
           write("<td align='right'><img src='../images/logo2.JPG' width='120' height='120'></td>");
			   write("<td align='center'>");
   			   write("<p>National Center for Faculty and <br/>");
			   write("   Leadership Development  <br/>");
               write("       NCFLD/IBCT </p></td>");       
           write("<td align='left'><img src='../images/logo1.JPG' width='150' height='150'/></td>");
   					 write("</tr></table><br/>");
                     write(contentValue);
                     write("</body></html>");
                          close();
                        }
                        mywind.focus();

                 }
 function doPrint__()
                 {
                   var contentValue = document.getElementById("content").innerHTML;
                   var disp_setting ="toolbar=1,location=0,directories=0,menubar=0,"; 
                       disp_setting+="scrollbars=1,width=800,height=600,left=100,top=100"; 
                   var mywind       = open("","",disp_setting);

                   with(mywind.document)
                        {
                          open();
                     write("<html><body onLoad='self.print()'>");
					 write("<table width='800' border='0' align='center'><tr>")
           write("<td align='right'><img src='../DataBase/images/logo2.JPG' width='120' height='120'></td>");
			   write("<td align='center'>");
   			   write("<p>National Center for Faculty and <br/>");
			   write("   Leadership Development  <br/>");
               write("       NCFLD/IBCT </p></td>");         
           write("<td align='left'><img src='../DataBase/images/logo1.JPG' width='150' height='150'/></td>");
   					 write("</tr></table><br/>");
                     write(contentValue);
                     write("</body></html>");
                          close();
                        }
                        mywind.focus();

                 }
				 
				 
// Data Entry Validation				 
				 
 function doValidate()
  {
	flage = true ;
	  if( flage == true )
	  {
      var name = document.myform.Name.value;
	  myRegExp = /[a-zA-z]+/ ;
	  if( myRegExp.test(name)== 0)
	  	     {
		   alert(" Please enter your name.");
		   document.myform.name.focus();
		   flage = false ; 
		    
		     }
	  }	
	  
	   if(flage == true)	 
	  {	 
	  var address = document.myform.Address.value;
	  myRegExp = /[a-zA-Z0-9]+/ ;
	  if(myRegExp.test(address) == 0)
	     {
		   alert(" Please enter Address. ");
		   document.myform.Address.focus();
		   flage = false ;
		 }	
	  }	
	  
	  if(flage == true)	 
	  {	 
	  var mail = document.myform.Email.value;
	  myRegExp = /[a-zA-Z0-9]+\@[a-z]+\.[a-z]/ ;
	  if(myRegExp.test(mail) == 0)
	     {
		   alert(" Please enter your e-mail. ");
		   document.myform.Email.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  
	  
	   if(flage == true)	 
	  {	 
	  var officeTele = document.myform.OfficeTele.value;
	  myRegExp = /[0-9]+/ ;
	  if(myRegExp.test(officeTele) == 0)
	     {
		   alert(" Please enter Office telephone. ");
		   document.myform.OfficeTele.focus();
		   flage = false ;
		 }	
	  }	 
	  
	   if(flage == true)	 
	  {	 
	  var homeTele  = document.myform.HomeTele.value;
	  myRegExp = /[0-9]+/ ;
	  if(myRegExp.test(homeTele) == 0)
	     {
		   alert(" Please enter Home telephone. ");
		   document.myform.HomeTele.focus();
		   flage = false ;
		 }	
	  }	 
	  
	   if(flage == true)	 
	  {	 
	  var mobile = document.myform.Mobile.value;
	  myRegExp = /[0-9]+/ ;
	  if(myRegExp.test(mobile) == 0)
	     {
		   alert(" Please enter Mobile. ");
		   document.myform.Mobile.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  
	 
	     if(flage == true)
	        { alert("Data Inserted successfully ");	
				    document.myform.submit();
                    return true;
		   }
		   
	return ;	 
     }
	 
//// Text Editor
//
//function submitForm() {
//
//updateRTE('Experience'); 
//return true; //Set to false to disable form submission, for easy debugging.
////updateRTEs(); // multiple rich text editors inside the form
//}
//
//// Validation for Quality Page
//
//function doValidateQuality()
// {
//	flage = true ;
//	  
//	 if( flage == true )
//	  {
//      var IdNo = document.myform.IDNumber.value;
//	  myRegExp = /\d{14}/ ;
//	  if( myRegExp.test(IdNo)== 0)
//	  	     {
//		   alert("Please enter your I.D. Number with 14 Digits.");
//		   document.myform.IDNumber.focus();
//		   flage = false ; 
//		    
//		     }
//	  }	
//	  
//	  if( flage == true )
//	  {
//      var name = document.myform.Name.value;
//	  myRegExp = /[a-zA-z]+/ ;
//	  if( myRegExp.test(name)== 0)
//	  	     {
//		   alert(" Please enter your name.");
//		   document.myform.Name.focus();
//		   flage = false ; 
//		    
//		     }
//	  }	
//	  
//	  if(flage == true)	 
//	  {	 
//	  var mail = document.myform.Email.value;
//	  myRegExp = /[a-zA-Z0-9]+\@[a-z]+\.[a-z]/ ;
//	  if(myRegExp.test(mail) == 0)
//	     {
//		   alert(" Please enter a vaild e-mail address. ");
//		   document.myform.Email.focus();
//		   flage = false ;
//		 }	
//	  }	 
//	  
//	  if(flage == true)	 
//	  {	 
//	  var mobile = document.myform.Mobile.value;
//	  myRegExp = /[0-9]+/ ;
//	  if(myRegExp.test(mobile) == 0)
//	     {
//		   alert(" Please enter Mobile. ");
//		   document.myform.Mobile.focus();
//		   flage = false ;
//		 }	
//	  }	 
//	  
//	  
//	     if(flage == true)
//	        { 	     
//			       
//					submitForm();
//				    document.myform.submit();
//                    return true;
//		   }
//		   
//	return ;	 
//     }


// Text Editor

function submitFormReg() {

updateRTEs(); // multiple rich text editors inside the form
return true; //Set to false to disable form submission, for easy debugging.
} 
// Validation for Registration Page


function doValidateRegistration()
 {
	flage = true ;
	  
	 if( flage == true )
	  { 
	    if(window.document.getElementById("div10").style.display =="inline")
		  {
      var IdNo = document.myform.IDNo.value;
	  myRegExp = /\d{14}/ ;
	  if( myRegExp.test(IdNo)== 0)
	  	     {
		   alert("Please enter your I.D. Number with 14 Digits.");
		   document.myform.IDNo.focus();
		   flage = false ; 
		    
		     }
		  }
	  }	
	  
	  if( flage == true )
	  {
      var name = document.myform.Name.value;
	  myRegExp = /[a-zA-z]+/ ;
	  if( myRegExp.test(name)== 0)
	  	     {
		   alert(" Please enter your name.");
		   document.myform.Name.focus();
		   flage = false ; 
		    
		     }
	  }	
	  
	  //if( flage == true )
//	  {
//      var university = document.myform.University.value;
//	  myRegExp = /[a-zA-z]+/ ;
//	  if( myRegExp.test(university)== 0)
//	  	     {
//		   alert(" Please enter your university.");
//		   document.myform.University.focus();
//		   flage = false ; 
//		    
//		     }
//	  }	
	  
	   if(flage == true)	 
	  {	 
	  var mobile = document.myform.Mobile.value;
	  myRegExp = /[0-9]+/ ;
	  if(myRegExp.test(mobile) == 0)
	     {
		   alert(" Please enter Mobile. ");
		   document.myform.Mobile.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  if(flage == true)	 
	  {	 
	  var mail = document.myform.Email.value;
	  myRegExp = /[a-zA-Z0-9]+\@[a-z]+\.[a-z]/ ;
	  if(myRegExp.test(mail) == 0)
	     {
		   alert(" Please enter a vaild e-mail address. ");
		   document.myform.Email.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  if( flage == true )
	  {
      var birthDate = document.myform.BirthDate.value;
	 myRegExp = /\d{4}-?\d{2}-?\d{2}/ ;
	  if( myRegExp.test(birthDate)== 0)
	  	     {
		   alert(" Please enter your Birth Date.");
		   document.myform.BirthDate.focus();
		   flage = false ; 
		    
		     }
	  }	
	  
	   if( flage == true )
	  {
		  if(window.document.getElementById("DateAppear").style.display =="inline"){
      var date1 = document.myform.Date1.value;
	 myRegExp = /\d{4}-?\d{2}-?\d{2}/ ;
	  if( myRegExp.test(date1)== 0)
	  	     {
		   alert(" Please enter your TOT workshop Date.");
		   document.myform.Date1.focus();
		   flage = false ; 
		    
		     }
		  }
	  }	
	  
	  if(flage == true)	 
	  {	 
	  var workshop = document.myform.Workshop.value;
	  myRegExp = /[a-zA-Z0-9]+/ ;
	  if(myRegExp.test(workshop) == 0)
	     {
		   alert(" Please enter the workshop. ");
		   document.myform.Workshop.focus();
		   flage = false ;
		 }	
	  }	
	  
	   if(flage == true)	 
	  {	 
	  var place = document.myform.Place.value;
	  myRegExp = /[a-zA-Z0-9]+/ ;
	  if(myRegExp.test(place) == 0)
	     {
		   alert(" Please enter the place of workshop. ");
		   document.myform.Place.focus();
		   flage = false ;
		 }	
	  }
	  
	   if(flage == true)	 
	  {	 
	  var date2 = document.myform.Date2.value;
	  myRegExp = /[a-zA-Z0-9]+/ ;
	  if(myRegExp.test(date2) == 0)
	     {
		   alert(" Please enter the date of workshop. ");
		   document.myform.Date2.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  
	 
	/* if(flage == true)	 
	  {	 
	  var date = document.getElementById('Date').value;
	  myRegExp = /\d{4}-?\d{2}-?\d{2}/ ;
	  if(myRegExp.test(date) == 0)
	     {
		   alert(" Please enter Date , in the form (year - month - Day). ");
		   document.getElementById('Date').focus();
		   flage = false ;
		 }	
	  }	*/
	   
	  
	     if(flage == true)
	        { 	     

				    //submitFormReg();
				    document.myform.submit();
                    return true;
		   }
		   
	return ;	 
     }




////////////////////////////////////////Quality Validation //////////////////////////////////
function doValidateQuality()
 {
	flage = true ;
	  
	 if( flage == true )
	  { 
	    if(window.document.getElementById("div10").style.display =="inline")
		  {
      var IdNo = document.myform.IDNumber.value;
	  myRegExp = /\d{14}/ ;
	  if( myRegExp.test(IdNo)== 0)
	  	     {
		   alert("Please enter your I.D. Number with 14 Digits.");
		   document.myform.IDNumber.focus();
		   flage = false ; 
		    
		     }
		  }
	  }	
	  
	  if( flage == true )
	  {
      var name = document.myform.Name.value;
	  myRegExp = /[a-zA-z]+/ ;
	  if( myRegExp.test(name)== 0)
	  	     {
		   alert(" Please enter your name.");
		   document.myform.Name.focus();
		   flage = false ; 
		    
		     }
	  }	
	  
	  //if( flage == true )
//	  {
//      var university = document.myform.University.value;
//	  myRegExp = /[a-zA-z]+/ ;
//	  if( myRegExp.test(university)== 0)
//	  	     {
//		   alert(" Please enter your university.");
//		   document.myform.University.focus();
//		   flage = false ; 
//		    
//		     }
//	  }	
	  
	   if(flage == true)	 
	  {	 
	  var mobile = document.myform.Mobile.value;
	  myRegExp = /[0-9]+/ ;
	  if(myRegExp.test(mobile) == 0)
	     {
		   alert(" Please enter Mobile. ");
		   document.myform.Mobile.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  if(flage == true)	 
	  {	 
	  var mail = document.myform.Email.value;
	  myRegExp = /[a-zA-Z0-9]+\@[a-z]+\.[a-z]/ ;
	  if(myRegExp.test(mail) == 0)
	     {
		   alert(" Please enter a vaild e-mail address. ");
		   document.myform.Email.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  if( flage == true )
	  {
      var birthDate = document.myform.BirthDate.value;
	 myRegExp = /\d{4}-?\d{2}-?\d{2}/ ;
	  if( myRegExp.test(birthDate)== 0)
	  	     {
		   alert(" Please enter your Birth Date.");
		   document.myform.BirthDate.focus();
		   flage = false ; 
		    
		     }
	  }	
	  
	 
	 
	     if(flage == true)
	        { 	     

				    //submitFormReg();
				    document.myform.submit();
                    return true;
		   }
		   
	return ;	 
     }


////////////////////////////////////////Quality 1  Validation //////////////////////////////////
function doValidateQuality1()
 {
	flage = true ;
	  
	 if( flage == true )
	  { 
	    if(window.document.getElementById("div10").style.display =="inline")
		  {
      var IdNo = document.myform.IDNo.value;
	  myRegExp = /\d{14}/ ;
	  if( myRegExp.test(IdNo)== 0)
	  	     {
		   alert("Please enter your I.D. Number with 14 Digits.");
		   document.myform.IDNo.focus();
		   flage = false ; 
		    
		     }
		  }
	  }	
	  
	  if( flage == true )
	  {
      var name = document.myform.Name.value;
	  myRegExp = /[a-zA-z]+/ ;
	  if( myRegExp.test(name)== 0)
	  	     {
		   alert(" Please enter your name.");
		   document.myform.Name.focus();
		   flage = false ; 
		    
		     }
	  }	
	  
	  //if( flage == true )
//	  {
//      var university = document.myform.University.value;
//	  myRegExp = /[a-zA-z]+/ ;
//	  if( myRegExp.test(university)== 0)
//	  	     {
//		   alert(" Please enter your university.");
//		   document.myform.University.focus();
//		   flage = false ; 
//		    
//		     }
//	  }	
	  
	   if(flage == true)	 
	  {	 
	  var mobile = document.myform.Mobile.value;
	  myRegExp = /[0-9]+/ ;
	  if(myRegExp.test(mobile) == 0)
	     {
		   alert(" Please enter Mobile. ");
		   document.myform.Mobile.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  if(flage == true)	 
	  {	 
	  var mail = document.myform.Email.value;
	  myRegExp = /[a-zA-Z0-9]+\@[a-z]+\.[a-z]/ ;
	  if(myRegExp.test(mail) == 0)
	     {
		   alert(" Please enter a vaild e-mail address. ");
		   document.myform.Email.focus();
		   flage = false ;
		 }	
	  }	 
	  
	  if( flage == true )
	  {
      var birthDate = document.myform.BirthDate.value;
	 myRegExp = /\d{4}-?\d{2}-?\d{2}/ ;
	  if( myRegExp.test(birthDate)== 0)
	  	     {
		   alert(" Please enter your Birth Date.");
		   document.myform.BirthDate.focus();
		   flage = false ; 
		    
		     }
	  }	
	  
	 
	 
	     if(flage == true)
	        { 	     

				    //submitFormReg();
				    document.myform.submit();
                    return true;
		   }
		   
	return ;	 
     }


// Chain Select
function doChain(form){

 for (var i=0; i<form.length ;i++)
    {

     var tempobj = form.elements[i];

     if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && tempobj.name.toLowerCase() == "faculty" &&
	    tempobj.value.toLowerCase()== "others")
		{
       
        tempobj.disabled = true;		
		tempobj.name     = "neglect" ;
		form.OtherFaculty.disabled = false;
		form.OtherFaculty.id = "Faculty" ;
		form.OtherFaculty.name= "Faculty" ;
		
		return true;

       }
	 
     }
 }
 
 
 // Chain Select Faculty for Registration form
function doChainFaculty(form){

 for (var i=0; i<form.length ;i++)
    {

     var tempobj = form.elements[i];

     if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && tempobj.name.toLowerCase() == "faculty" &&
	    tempobj.value.toLowerCase()== "others")
		{
       
        tempobj.disabled = true;		
		tempobj.name     = "neglect" ;
		form.OtherFaculty.style.display = 'inline';
		window.document.getElementById("div8").style.display = 'inline';
		
		form.OtherFaculty.id = "Faculty" ;
		form.OtherFaculty.name= "Faculty" ;
		
		return true;

       }
	 
     }
	 
	 
 }
 
 // Chain For University
 function doChainUniversity(form)
 {

for (var i=0; i<form.length ;i++)
    {

     var tempobj = form.elements[i];

     if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && 
		tempobj.name.toLowerCase() == "university" &&
	    tempobj.value.toLowerCase()== "others")
		{
       
        tempobj.disabled = true;		
		tempobj.name     = "neglect" ;
		form.OtherUniversity.disabled = false;
		form.OtherUniversity.id = "University" ;
		form.OtherUniversity.name= "University" ;
		
		return true;

       }
	 
     } 
 }
 
 // Chain For University for Registration Page
 function doChainUniversityReg(form)
 {

for (var i=0; i<form.length ;i++)
    {

     var tempobj = form.elements[i];

     if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && 
		tempobj.name.toLowerCase() == "university" &&
	    tempobj.value.toLowerCase()== "others")
		{
       
        tempobj.disabled = true;		
		tempobj.name     = "neglect" ;
		form.OtherUniversity.style.display = 'inline';
		window.document.getElementById("div7").style.display = 'inline';
		form.OtherUniversity.id = "University" ;
		form.OtherUniversity.name= "University" ;
		
		return true;

       }
	 
     }
	 
	 
 }

// Chain For Work Place
/* function doChainWorkPlace(form)
 {

  for (var i=0; i<form.length ;i++)
      {

        var tempobj = form.elements[i];

        if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && 
		tempobj.name.toLowerCase() == "workplace" &&
	    tempobj.value.toLowerCase()== "other organizations")
		{
       
        tempobj.disabled = true;
		form.Faculty.disabled = true;
		form.Title.disabled = true;
		form.University.disabled = true;
		window.document.getElementById("txtHint").disabled = true;
		window.document.getElementById("div1").style.display = 'inline';

		
		form.Faculty.name     = "neglect" ;
		form.OtherFaculty.disabled = false;
		form.OtherFaculty.id = "Faculty" ;
		form.OtherFaculty.name= "Faculty" ;
		
		form.Title.name     = "neglect" ;
		form.OtherTitle.disabled = false;
		form.OtherTitle.id = "Title" ;
		form.OtherTitle.name= "Title" ;
		
		tempobj.name     = "neglect" ;
		form.OtherWorkPlace.disabled = false;
		form.OtherWorkPlace.id = "WorkPlace" ;
		form.OtherWorkPlace.name= "WorkPlace" ;
		
		return true;

       }
	 
     }	 
 }*/



 // Chain For Country
 function doChainCountry(form)
 {

  for (var i=0; i<form.length ;i++)
      {

        var tempobj = form.elements[i];

        if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && 
		tempobj.name.toLowerCase() == "country" &&
	    tempobj.value.toLowerCase()== "others")
		{
       
        tempobj.disabled = true;		
		tempobj.name     = "neglect" ;
		form.OtherCountry.disabled = false;
		form.OtherCountry.id = "Country" ;
		form.OtherCountry.name= "Country" ;
		
		return true;

       }
	 
     }	 
 }
 
 
 // Chain For Country for Regstration Page
 function doChainCountryReg(form)
 {

  for (var i=0; i<form.length ;i++)
      {

        var tempobj = form.elements[i];

        if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && 
		tempobj.name.toLowerCase() == "country" &&
	    tempobj.value.toLowerCase()== "others")
		{
       
        tempobj.disabled = true;		
		tempobj.name     = "neglect" ;
		form.OtherCountry.style.display = 'inline';
		window.document.getElementById("div9").style.display = 'inline';
		window.document.getElementById("div10").style.display = 'none';
		
		form.OtherCountry.id = "Country" ;
		form.OtherCountry.name= "Country" ;
		
		return true;

       }
	   
	    if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && 
		tempobj.name.toLowerCase() == "country" &&
	    tempobj.value.toLowerCase()!= "egypt")
		{
       
        
		window.document.getElementById("div10").style.display = 'none';
		
		
		
		return true;

       }
	   
	   if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && 
		tempobj.name.toLowerCase() == "country" &&
	    tempobj.value.toLowerCase()== "egypt")
		{
       
        
		window.document.getElementById("div10").style.display = 'inline';
		
		
		
		return true;

       }
	 
     }	 
 }
 
 // Chain For Title
 function doChainTitle(form)
 {

  for (var i=0; i<form.length ;i++)
      {

        var tempobj = form.elements[i];

        if(
	    tempobj.type.toLowerCase()!="submit" && 
	    tempobj.type.toLowerCase()!="button" && 
		tempobj.name.toLowerCase() == "title"&&
	    tempobj.value.toLowerCase()== "others")
		{
       
        tempobj.disabled = true;		
		tempobj.name     = "neglect" ;
		form.OtherTitle.disabled = false;
		form.OtherTitle.id  = "Title" ;
		form.OtherTitle.name= "Title" ;
		
		return true;

       }
	 
     }	 
 }




// Get Form vlaue

 function FormValue(form)
    {
    if (form.elements[0].value =="RecentProgram"){
		
	 var st ="select RecentProg,ID,Name,Title,Faculty,University,Country,Date,Programme,Status from report where RecentProg=' '" ;
		
		}
	else{ 
	 var st ="select ID,Name,Title,Faculty,University,Country,Date,Programme,Status from report where "+ form.elements[0].name+"="+"'"+form.elements[0].value+"'" ;
	   }
	 
	 for(var i=1 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
			
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		 st +=" and RecentProg=' ' order by Name,University,Faculty, Date desc";
		 
	   window.location = "PHP/data.php?sqlst="+'"'+st+'"';	   
	 }
	 
function FormValuePass(form,Prog)
  {
     var st ="select ID,Name,Title,Faculty,University,Country,Date,Programme,Status from report where Status='Pass' And RecentProg=' ' And Programme="+"'"+Prog+"'" ;

	 for(var i=0 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
			
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		 st +=" order by Name asc";
		 
		 
		 if (Prog == "Internationally Certified Trainer")
		 {
window.location = "DataBase/PHP/dataPass.php?sqlst="+'"'+st+'"'+"&Prog="+Prog+"&t="+' '+"&d="+'Certified Since'+"&src=Certified.php";
			 }
	     else{
 window.location = "DataBase/PHP/dataPass.php?sqlst="+'"'+st+'"'+"&Prog="+Prog+"&t="+'Trainers' +"&d="+'Workshop Date'+"&src="+Prog+".php";
			}	   
	 }		
		
		
		
// Information Page	 
	 
    function FormValueInformation(form)
    {
     
	 if (form.elements[0].value =="RecentProgram"){
	 var st =
"select RecentProg,ID,Name,Title,Faculty,University,Country,Date,Programme,Status,Mobile,Email from report where RecentProg=' '" ;
		
		}
	else{ 
	 var st ="select ID,Name,Title,Faculty,University,Country,Date,Programme,Status,Mobile,Email from report where "+ form.elements[0].name+"="+"'"+form.elements[0].value+"'" ;
	}
	 
	 for(var i=1 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
			
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		 st +=" and RecentProg=' ' order by Name,University,Faculty, Date desc";
		 
	   window.location = "PHP/Information.php?sqlst="+'"'+st+'"';	   
	 }		
		

// Quality Page	 
    function FormValueQuality(form)
    {
     
	 
	 var st ="select ID,IDNo,Name,Experience,Faculty,University,ExpType,Date,Programme,Mobile,Email,QualityType from quality where "+ form.elements[0].name+"="+"'"+form.elements[0].value+"'" ;
	 
	 for(var i=1 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
			
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		  st +=" order by Name asc";
		 
	   window.location = "PHP/Quality.php?sqlst="+'"'+st+'"';	   
	 }		
   
// Registration Admin Page	 
    function FormValueReg(form)
    {
		if(form.elements[2].value == 'Egypt')
		{
			if(form.elements[0].value == 'reg1')
			{form.elements[0].value = 'reg1';
 var st ="select * from "+form.elements[0].value+" where "+ form.elements[1].name+"="+"'"+form.elements[1].value+"'" ;}
            else if(form.elements[0].value == 'reg2' || form.elements[0].value == 'reg3')
			{form.elements[0].value = 'reg2';
 var st ="select * from "+form.elements[0].value+" where "+ form.elements[1].name+"="+"'"+form.elements[1].value+"'" ;}
		}
		else
		{form.elements[0].value = 'reg3';
 var st ="select * from "+form.elements[0].value+" where "+ form.elements[1].name+"="+"'"+form.elements[1].value+"'" ;}
	 
	 for(var i=2 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
			
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		  st +=" order by ID asc";
		 
	   window.location = "PHP/Reg.php?WorkPlace="+form.elements[0].value+"&sqlst="+'"'+st+'"';	   
	 }
	 
	 // Registration Admin Page Quality	 
    function FormValueRegQuality(form)
    {
		if(form.elements[2].value == 'Egypt')
		{
			if(form.elements[0].value == 'reg1')
			{form.elements[0].value = 'reg1';
 var st ="select * from "+form.elements[0].value+" where "+ form.elements[1].name+"="+"'"+form.elements[1].value+"'" ;}
            else if(form.elements[0].value == 'reg2' || form.elements[0].value == 'reg3')
			{form.elements[0].value = 'reg2';
 var st ="select * from "+form.elements[0].value+" where "+ form.elements[1].name+"="+"'"+form.elements[1].value+"'" ;}
		}
		else
		{form.elements[0].value = 'reg3';
 var st ="select * from "+form.elements[0].value+" where "+ form.elements[1].name+"="+"'"+form.elements[1].value+"'" ;}
	 
	 for(var i=2 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
			
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		  st +=" order by University,Name asc";
		 
window.location = "PHP/RegQuality.php?WorkPlace="+form.elements[0].value+"&sqlst="+'"'+st+'"';	   
	 }		
   
   

// DataModel Page	 
    function FormValueDataModel(form)
    {
     
	 
	 var st ="select ID,Name,Faculty,University,Type,Mobile,Email from datamodel where "+ form.elements[0].name+"="+"'"+form.elements[0].value+"'" ;
	 
	 for(var i=1 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
			
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		  st +=" order by Name asc";
		 
	   window.location = "PHP/DataModel.php?sqlst="+'"'+st+'"';	   
	 }		
   
   // DataModel Page	 
    function FormValueData_Model(form)
    {
     
	 
	 var st ="select ID,Name,Faculty,University,Type,Mobile,Email,BirthDate from data_model where "+ form.elements[0].name+"="+"'"+form.elements[0].value+"'" ;
	 
	 for(var i=1 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
			
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		  st +=" order by Name asc";
		 
	   window.location = "PHP/Data_Model.php?sqlst="+'"'+st+'"';	   
	 }		
   
	 
/// TOT_result function
function TOT_result(form,Prog)
    {
     var st = "select Name,Title,Faculty,University,Competence from report where Publish='yes' and Status='Pass' And "+ form.elements[0].name+"="+"'"+form.elements[0].value+"'" ;

	 for(var i=1 ; i < form.length ; i++)
		{
			var tempobj  = form.elements[i];
            if(tempobj.value.length != 0 && 
               tempobj.type.toLowerCase()!="submit" && 
	           tempobj.type.toLowerCase()!="button" )
	         {
				 st += " And "+tempobj.name+"=" ;
				 st += "'"+ tempobj.value +"'";
			 }
			
		 }
		var Prog = document.getElementById('Programme').value ;
		var workshop = document.getElementById('WorkShop').value ;
		 st +=" order by Name asc";		
    window.location = "TOT_result.php?sqlst="+'"'+st+'"'+"&Prog="+Prog+"&workshop="+workshop+"&word=<--Select Programme #flag";
			   
	 }

//function Note(form)
//    {
//	 for(var i=form.length; i > 1 ; i--)
//		{
//			var tempobj  = form.elements[i];
//            if(tempobj.value.length != 0 && 
//               tempobj.type.toLowerCase()!="submit" && 
//	           tempobj.type.toLowerCase()!="button" )
//	         {
//                 FieldName  += tempobj.name+"," ;
//				 FieldValue += "'"+ tempobj.value +"',";
//
//			 }
//			
//		 }
// var st = "insert into notes ("+FieldName+form.elements[0].name+") values('"+FieldValue+"'+'"+form.elements[0].value+"')" ; 
//			
//    window.location = "Notes.php";
//		   
//	 }	 

function Chainselect()
  {
	     
		 var currentTime = new Date();
		 var year = currentTime.getFullYear();
		     year = year - 1 ;
	     var Prog = document.getElementById('Programme').value ;
         var workshop;
		 var counter;
if(Prog == "Preparatory" || Prog == "Supplementary")
		 {
st = "select Distinct WorkShop,Date from report where Date >="+"'"+year+"-01-01' And Status='Pass' And Programme="+"'"+Prog+"' order by Date";
		
		}
		else
		{
st ="select Distinct WorkShop,CompDate from report where CompDate >="+"'"+year+"-01-01' And Status='Pass' And Programme="+"'"+Prog+"' order by CompDate";
		}		
		
window.location = "TOT_result.php?sqlstList="+'"'+st+'"'+"&Prog="+Prog+"&word=Select workshop--> #flag";
	return true;

     }
	 