<?
include 'include/function_certificate.php';
if ($_REQUEST["id"]=='TO009'){
		if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
				$url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO009';
		}else{
				$url='http://www.teflonline.com/pdf/certificate.php?id=TO009';
		}  	 
		$full=1;
		 $hour= 120;
		 $decryptName='Mary Davis';
		 $decryptId=$_REQUEST["id"];
		 $acu1='B';
		 $acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
		 $grammar='YES';
		 $porcAcu=100;
}
elseif ($_REQUEST["id"]=='TO0005032'){
		if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
				$url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO0005032';
		}else{
				$url='http://www.teflonline.com/pdf/certificate.php?id=TO0005032';
		}  	 
		$full=1;
		 $hour= 60;
		 $decryptName='Justin Brown';
		 $decryptId=$_REQUEST["id"];
		 $acu1='A';
		 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
		 $grammar='NO';
		 $porcAcu=100;
}
elseif ($_REQUEST["id"]=='TO0000305'){
		if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
				$url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO0005032';
		}else{
				$url='http://www.teflonline.com/pdf/certificate.php?id=TO0005032';
		}  	 
		$full=1;
		 $hour= 60;
		 $decryptName='Katie Arce';
		 $decryptId=$_REQUEST["id"];
		 $acu1='A';
		 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
		 $grammar='YES';
		 $porcAcu=100;
}


elseif ($_REQUEST["id"]=='TO0001551'){
		if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
				$url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO0001551';
		}else{
				$url='http://www.teflonline.com/pdf/certificate.php?id=TO0001551';
		}  	 
		$full=1;
		 $hour= 60;
		 $decryptName='Paul Kendall';
		 $decryptId=$_REQUEST["id"];
		 $acu1='A';
		 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
		 $grammar='NO';
		 $porcAcu=100;
}
elseif ($_REQUEST["id"]=='TO0005557'){
		if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
				$url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO0005557';
		}else{
				$url='http://www.teflonline.com/pdf/certificate.php?id=TO0005557';
		}  	 
		$full=1;
		 $hour= 60;
		 $decryptName='Christopher Ricciardi';
		 $decryptId=$_REQUEST["id"];
		 $acu1='A';
		 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
		 $grammar='NO';
		 $porcAcu=100;
}
elseif ($_REQUEST["id"]=='TO0021134'){
		if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
				$url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO0021134';
		}else{
				$url='http://www.teflonline.com/pdf/certificate.php?id=TO0021134';
		}  	 
		$full=0;
		 $hour= 40;
		 $decryptName='Stephanie Taplin';
		 $decryptId=$_REQUEST["id"];
		 $acu1='A';
		 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
		 $grammar='NO';
		 $porcAcu=100;
}

elseif ($_REQUEST["id"]=='TO0000489'){
		if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
				$url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO0005032';
		}else{
				$url='http://www.teflonline.com/pdf/certificate.php?id=TO0000489';
		}  	 
		$full=1;
		 $hour= 60;
		 $decryptName='Eboni Bailey-Bonaiti';
		 $decryptId=$_REQUEST["id"];
		 $acu1='A';
		 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
		 $grammar='NO';
		 $porcAcu=100;
}


elseif ($_REQUEST["id"]=='TO0002781'){
                if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
                                $url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO0002781';
                }else{
                                $url='http://www.teflonline.com/pdf/certificate.php?id=TO0002781';
                }
                $full=1;
                 $hour= 60;
                 $decryptName='Christopher Kerestes';
                 $decryptId=$_REQUEST["id"];
                 $acu1='A';
                 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
                 $grammar='NO';
                 $porcAcu=100;
}

elseif ($_REQUEST["id"]=='TO0004988'){
                if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
                                $url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php?id=TO0004988';
                }else{
                                $url='http://www.teflonline.com/pdf/certificate.php?id=TO0004988';
                }
                $full=1;
                 $hour= 60;
                 $decryptName='Ming Chung';
                 $decryptId=$_REQUEST["id"];
                 $acu1='A';
                 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
                 $grammar='NO';
                 $porcAcu=100;
}

elseif ($_REQUEST["id"]=='TO0000771'){
                $url='http://www.teflonline.com/pdf/certificate.php?id=TO0000771';
                $full=1;
                 $hour= 80;
                 $decryptName='Dana Jensen';
                 $decryptId=$_REQUEST["id"];
                 $acu1='A';
                 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
                 $grammar='NO';
                 $porcAcu=100;
}
elseif ($_REQUEST["id"]=='TO0003600'){
                $url='http://www.teflonline.com/pdf/certificate.php?id=TO0003600';
                $full=1;
                 $hour= 120;
                 $decryptName='Maria Falk';
                 $decryptId=$_REQUEST["id"];
                 $acu1='A';
                 $acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
                 $grammar='YES';
                 $porcAcu=100;
}
elseif ($_REQUEST["id"]=='TO0023173'){
                $url='http://www.teflonline.com/pdf/certificate.php?id=TO0023173';
                $full=1;
                 $hour= 10;
                 $decryptName='DANE JUDDD';
                 $decryptId=$_REQUEST["id"];
                 $acu1='C';
                 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
                 $grammar='NO';
                 $porcAcu=100;
}
elseif ($_REQUEST["id"]=='TO0001177'){
                $url='http://www.teflonline.com/pdf/certificate.php?id=TO0001177';
                $full=1;
                 $hour= 70;
                 $decryptName='JENNIFER CULLISON';
                 $decryptId=$_REQUEST["id"];
                 $acu1='A';
                 //$acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
		 $acuBL ="test";
                 $grammar='NO';
                 $porcAcu=100;
}
elseif ($_REQUEST["id"]=='TO0035168'){
                $url='http://www.teflonline.com/pdf/certificate.php?id=TO0035168';
                $full=1;
                 $hour= 140;
                 $decryptName='Joseph Patrick Gerard Alfone';
                 $decryptId=$_REQUEST["id"];
                 $acu1='A';
                 $acu = $cueMod = $cueBLYL = $acuBL = $acuYL =  'TEST';
                 $grammar='YES';
                 $porcAcu=100;
}


else{
		if (empty($_REQUEST["n"])) {
		 header("location:verification.php");;
		}
		$acu = $cueMod = $cueBLYL = $acuBL = $acuYL = 0;
		if($_SERVER["HTTP_HOST"] == "bridgeweb.dyndns.org" || $_SERVER["HTTP_HOST"] == "192.168.1.120" ){
				$url='http://bridgeweb.dyndns.org/works/teflonline/site/pdf/certificate.php';
		}else{
				$url='http://www.teflonline.com/pdf/certificate.php?id=';
		}  	 
		$n = $_REQUEST["n"];
		$s = $_REQUEST["s"];
		$decryptName = web360_decrypt($n, 'web360', 5);
		$decryptId = web360_decrypt($s, 'web360', 5);
		$sql = " SELECT * " .
					 " FROM student_40 " .
					 " WHERE StudentId = '$decryptId' LIMIT 1";
		$con = db_connectTO();
		$url = $url.$decryptId;
		$course40 = mysql_query($sql, $con);
		$row40 = mysql_fetch_array($course40);
		$full=1; // si queda en 0 solo tiene curso de 40 hs.
		if ($row40['status']==1){
			$full=0;
		}
if ($full==1){
	$cantcourse=2;
	$porcent=1;
	$row = getUserTeflGraduated($decryptId );
}else{
	$cantcourse=241;
	$porcent=10/3;
	$row = getUserTeflGraduatedBasic($decryptId);
}

if(($row[0]['cant']==2 && $full==1) || ($row['cant']==241 && $full==0)){	
					$sqlQuery = "SELECT SS.Correlativity, m.Title, m.ModuleId AS mi, m.Description AS descr, "
											." m.Content AS cont, m.ModuleOrder AS mo "
											." FROM Modules as m, Suscriptions S, Students_Status SS "
											." WHERE m.ModuleId = S.ModuleId AND m.Type_Suscription = SS.Type_Suscription AND SS.StudentId = S.StudentId "
											." AND S.StudentId = '$decryptId' AND m.ModuleId > 50 "
											." AND m.ModuleOrder != 15 " 
											." ORDER BY m.ModuleOrder ASC";
					
					$resultNota = mysql_query($sqlQuery);
					
					
	//  PARA CALCULAR IGUAL QUE EN TO			
for($i = 100; $i < 115; $i++){
	$prom = number_format(Porc($i,$decryptId, 'Quiz')+Porc($i,$decryptId, 'Assig'),2); 
	if($prom != '0.00'){
		$promParcial += $prom;
		$promCount++;
	}
}
$acu1 = number_format(($promParcial/$promCount)*$porcent,0);				
///  FIN TO					
					while ($rowNota = mysql_fetch_array($resultNota)){
					if(($rowNota["mi"] < 114  )){
						/*	$acu = Porc($rowNota["mi"],$row["ID"], "Quiz")+Porc($rowNota["mi"],$row["ID"], "Assig") + $acu;
							$cueMod++;*/
						}elseif($rowNota["mi"] == 120){
							$acuBL = Porc($rowNota["mi"],$row["ID"], "Quiz")+Porc($rowNota["mi"],$row["ID"], "Assig");
							$cueBLYL++;
						}elseif($rowNota["mi"] == 121){
							$acuYL = Porc($rowNota["mi"],$row["ID"], "Quiz")+Porc($rowNota["mi"],$row["ID"], "Assig");
							$cueBLYL++;
						}
					}
					if ($full==0){
						$cueMod = 7;
					}
					$cueTot = $cueMod + $cueBLYL;
					list($NameGra, $NumGra) = TypeSuscrip($row["ID"]);
			//		$acu1 = ($acu != 0)? number_format(($acu/$cueMod)*$porcent,2):'0.00';
					$porcAcu=$acu1;
					$acu2 = (($acu+$acuBL+$acuYL) != 0)? number_format(($acu+$acuBL+$acuYL)/$cueTot,2):'0.00';
					
					if ($decryptId == "0028637")
					{$acu1="A";}
					else
					{$acu1=abcscore($acu1);} //Note Modules 60hs
					
					
					$acuBL=abcscore($acuBL); //Note BL 10hs
					$acuYL=abcscore($acuYL); //Note YL 10 hs
					$hour=0;
					if ($acu1 !='' && $full==1){
			  		$hour=60;
					}
					if ($acu1 !='' && $full==0){
					  $hour=40;
					}
					if ($acuBL !=''){
					  $hour=$hour+10;
					}
					if ($acuYL !=''){
					  $hour=$hour+10;
					}
				$arrStudent =	mysql_fetch_array(getUserLandingFinalTO($decryptId));
			  if(isset($arrStudent['score'])){
			  	if ($arrStudent['score'] >= 70){
						$hour=$hour+40;
						$grammar='YES';
					}
				}
		}
		$url = $url."&hour=".$hour;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Certificate Verification</title>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
-->
</style>
<script language="JavaScript">
function ValidaForm(){	
		document.certificate.submit();

}
</script>
<link href="../css/css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="355" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="16%" rowspan="2"><img src="../images_bt/certificate_logo.jpg" width="195" height="74" /></td>
        <td width="84%" height="38"><img src="../images_bt/certif_verf.gif" width="173" height="15" vspace="15" /></td>
      </tr>
      <tr>
        <td height="19" background="../images_bt/certificate_deg.jpg" class="menu8"><br />
          <span class="menu14"><a href="javascript:history.back(1)" class="menu14">Certificate Verification</a> &gt; <a href="javascript:history.back(1)" class="menu14"></a><span class="Texto-comen">Verification Results </span></span></td>
      </tr>
    </table>
      <table width="956" height="353" border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><img src="../images_bt/certificate_sa.jpg" width="12" height="9" /></td>
          <td width="504" class="TextoNegro18"></td>
          <td width="13" class="TextoNegro18">&nbsp;</td>
          <td width="429" height="40" class="TextoNegro18">&nbsp;</td>
        </tr>
        <tr>
          <td width="13">&nbsp;</td>
          <td width="504"><img src="../images_bt/certificate_cuad.jpg" width="448" height="32" /></td>
          <td width="10">&nbsp;</td>
          <td width="429" height="32">&nbsp;</td>
        </tr>
        <tr>
          <td>&nbsp;</td>
        <td align="left" valign="middle" class="Texto"><span class="Texto18negro"> 
        	
<?
if ($porcAcu >= 70){ ?>        	
        	This individual has   received <?if ($hour==80){echo 'an';}else{echo'a';}?>
                  - Hour TEFL Online   Certificate, which includes the following:
<?}else{?>      
<b>Unfortunately, you have not met the requirements to receive a certificate. You must complete the course with a 70% or higher to receive a certificate.</b>
<?}?>      
      </span></span><span class="Texto18"><br />
                <br />
                </span>
                
                
<? if ($porcAcu >= 70){ ?>                 
	            <form action="" method="post" name="certificate"  target="_blank">
	        		<input name="id" type="hidden" value="" />
	        		<input name="hour" type="hidden" value="" />
                <table width="100%" height="224" border="0" cellpadding="2" cellspacing="2">
                  <tr>
                    <td width="45%" height="36" align="center" valign="middle" bgcolor="#1D599F" class="Menu6"><strong class="Texto6grBold">Qualification</strong></td>
                    <td width="9%" align="center" bgcolor="#1D599F" class="Menu6"><strong class="Texto6grBold">Hours</strong></td>
                    <td width="9%" align="center" bgcolor="#1D599F" class="Menu6"><strong class="Texto6grBold">Grade</strong></td>
                    <td width="37%" align="center" bgcolor="#1D599F" class="Menu6"><strong class="Texto6grBold">Download Certificate</strong></td>
                  </tr>
<? 
                  	if ($acu1 !='' && $full==1){
?>
                  <tr>
                    <td width="45%" height="35" align="left" bgcolor="#E6EEF9">&nbsp;&nbsp;<a href="teflonline_description.php" class="Menu_4">Educator   TEFL Online Course</a></td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><b>60</b></td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><a href="grading.php" class="Menu13">
                                          </a></td>
                    <td width="37%" rowspan="4" align="center" bgcolor="#E6EEF9" class="Texto18negro">To download a printable <br />
                    copy of the graduate's official certificate, please click on the button below. The number of hours noted on this certificate will be updated as the person completes his/her TEFL Online course and any additional endorsements.</td>
                  </tr>
<?
                  }
                 	if ($acu1 !='' && $full==0){
?>
                  <tr>
                    <td width="45%" height="35" align="left" bgcolor="#E6EEF9">&nbsp;&nbsp;<a href="teflonline_description_40.php" class="Menu_4">Basic   TEFL Online Course</a></td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><b>40</b></td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><a href="grading.php" class="Menu13">
                                          </a></td>
                    <td width="37%" rowspan="4" align="center" bgcolor="#E6EEF9" class="Texto18negro">To download a printable <br />
                    copy of the graduate's official certificate, please click on the button below. The number of hours noted on this certificate will be updated as the person completes his/her TEFL Online course and any additional endorsements.</td>
                  </tr>
<?
                  }               
               
                  if ($acuYL !=''){
?>
                  <tr>
                    <td width="45%" height="47" align="left" bgcolor="#E6EEF9">&nbsp;&nbsp;<a href="young_learner.php" class="Menu_4">Young Learners Endorsement</a></strong> </td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><b>10</b></td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><a href="grading.php" class="Menu13">P</a></td>
                  </tr>
<?
                  } 
                  if ($acuBL !='' ){
?>
                  <tr>
                    <td width="45%" height="48" align="left" bgcolor="#E6EEF9">&nbsp;&nbsp;<a href="business_english_endorsement.php" class="Menu_4">Business English Endorsement</span></a> </td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><strong>10</strong></td>
                    <td width="9%" align="center" bgcolor="#E6EEF9" ><a href="grading.php" class="Menu13">P</a></td>
                  </tr>
<?
                  }
                  if ($grammar =='YES'){
?>
                  <tr>
                    <td width="45%" height="46" align="left" bgcolor="#E6EEF9">&nbsp;&nbsp; <a href="grammar_endorsement.php" class="Menu_4">Grammar Advisor Endorsement</span></a></b> </td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><strong>40</strong></td>
                    <td width="9%" align="center" bgcolor="#E6EEF9" ><a href="grading.php" class="Menu13">P </a></td>
                  </tr>
<?
                  }
?>
                </table>
                <table width="100%" height="100%" border="0" cellpadding="2" cellspacing="2">
                  <tr>
                    <td width="45%" height="21" align="right" bgcolor="#E6EEF9" class="Texto18negro"><strong>Total&nbsp;&nbsp;&nbsp;</strong></td>
                    <td width="9%" align="center" bgcolor="#E6EEF9"><strong></strong></td>
                    <td width="9%" align="right" bgcolor="#E6EEF9">&nbsp;</td>
                    <td width="37%" height="35" align="center" bgcolor="#E6EEF9"><img src="../images_bt/download_cert.gif" width="126" height="21" border="0" style="cursor: pointer;" onClick="_gaq.push(['_trackPageview', '/certificates/DownloadCertificate']);ValidaForm();" /></td>
                  </tr>
                  </table>
            </form>
<?}?>            
            <span class="Texto18"><br /></span><br />
          </td>
          <td align="left" valign="middle" class="Texto">&nbsp;</td>
          <td align="left" valign="middle" class="Texto"><span class="Texto18"><img src="../images_bt/accet.gif" width="406" height="182" /></span></td>
        </tr>
      </table>
       <table width="100%" border="0" cellspacing="0" cellpadding="0">
         <tr>
           <td width="10">&nbsp;</td>
           <td background="../images_bt/certificate_down.jpg"><img src="../images_bt/certificate_down.jpg" width="14" height="27" /></td>
           <td width="10">&nbsp;</td>
         </tr>
         <tr>
           <td>&nbsp;</td>
           <td height="45" align="center" class="Texto">BridgeTEFL offers a full spectrum of English teacher training services. <br />
             For more information on our programs and services, please click on any of the links below.</td>
           <td>&nbsp;</td>
         </tr>
         <tr>
           <td>&nbsp;</td>
           <td align="center" bgcolor="#F5F9FE"><p><span class="texto_tah12"><br />
               </span><span class="Titulo11">Teach English Worldwide</span><br />
               <br />
               <span class="Texto"><strong class="MenuBotonera"><a href="http://www.bridgetefl.com" target="_blank" class="Menu_cert">BridgeTEFL.com</a></strong>&mdash;TEFL &amp; CELTA Certification Courses Worldwide<br />
               <strong><a href="http://www.teflonline.com" target="_blank" class="Menu_cert">TEFLOnline.com</a></strong>&mdash;Online TEFL Certification Courses<br />
               <strong><a href="http://www.tefljobplacement.com" target="_blank" class="Menu_cert">TEFLJobPlacement.com</a></strong>&mdash;Guaranteed Job Placement Abroad<br />
               <strong><a href="http://www.grammaradvisor.com" target="_blank" class="Menu_cert">GrammarAdvisor.com</a></strong>&mdash;Grammar Guide for TEFL Teachers<br />
               <strong><a href="#" class="Menu_cert">TEFLVideos.com</a></strong>&mdash;Instructional Videos  for TEFL Teachers</span><br />
               <span class="TextoInt"><br />
               </span><span class="Texto-comen">Bridge-Linguatec Inc., 915 S. Colorado Blvd., Denver, CO, 80246 <br />
                 Toll-Free US &amp; Can: 1-800-437-0413 | Toll-Free UK: 0808-120-7613<br />
                 Worldwide: 303-785-8864 | Fax: 303-777-7246 </span></p>
               <p><span class="Texto"><img src="../images_bt/bridge_ling.gif" width="143" height="34" hspace="10" align="absmiddle" /> BridgeTEFL is a division of Bridge-Linguatec, Inc.</span><br />
                   <br />
             </p></td>
           <td>&nbsp;</td>
         </tr>
       </table></td>
  </tr>
</table>
<?
include 'google_analytics_certificates.php';
?>
</body>
</html>