<?php
require_once('Connections/icbs.php');

mysql_select_db($database_icbs, $icbs);
$query_RecordsetDate = "SELECT DATE_FORMAT(max(endDate) , '%M %d %Y') as endDate FROM meta";
$RecordsetDate = mysql_query($query_RecordsetDate, $icbs) or die(mysql_error());
$row_RecordsetDate = mysql_fetch_assoc($RecordsetDate);
$totalRows_RecordsetDate = mysql_num_rows($RecordsetDate);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetSbPDB = "SELECT sum(single_bb_only) as sumSbPDB FROM icbs WHERE code_pqs IS NULL";
$RecordsetSbPDB = mysql_query($query_RecordsetSbPDB, $icbs) or die(mysql_error());
$row_RecordsetSbPDB = mysql_fetch_assoc($RecordsetSbPDB);
$totalRows_RecordsetSbPDB = mysql_num_rows($RecordsetSbPDB);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetSbPQSUnique = "SELECT sum(single_bb_only) as sumSbPQSUnique FROM icbs WHERE code_pqs IS NOT NULL AND pqs_redundant = '0'";
$RecordsetSbPQSUnique = mysql_query($query_RecordsetSbPQSUnique, $icbs) or die(mysql_error());
$row_RecordsetSbPQSUnique = mysql_fetch_assoc($RecordsetSbPQSUnique);
$totalRows_RecordsetSbPQSUnique = mysql_num_rows($RecordsetSbPQSUnique);

mysql_select_db($database_icbs, $icbs);
$query_Recordset1SbPQSRedundant = "SELECT sum(single_bb_only) as sumSbPQSRedundant FROM icbs WHERE code_pqs IS NOT NULL AND pqs_redundant = '1'";
$Recordset1SbPQSRedundant = mysql_query($query_Recordset1SbPQSRedundant, $icbs) or die(mysql_error());
$row_Recordset1SbPQSRedundant = mysql_fetch_assoc($Recordset1SbPQSRedundant);
$totalRows_Recordset1SbPQSRedundant = mysql_num_rows($Recordset1SbPQSRedundant);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetBetaPDB = "SELECT single_bb_only FROM icbs WHERE single_bb_only = '0' AND code_pqs IS NULL";
$RecordsetBetaPDB = mysql_query($query_RecordsetBetaPDB, $icbs) or die(mysql_error());
$row_RecordsetBetaPDB = mysql_fetch_assoc($RecordsetBetaPDB);
$totalRows_RecordsetBetaPDB = mysql_num_rows($RecordsetBetaPDB);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetBetaPQSUnique = "SELECT single_bb_only FROM icbs WHERE single_bb_only = '0' AND code_pqs IS NOT NULL AND pqs_redundant = '0';";
$RecordsetBetaPQSUnique = mysql_query($query_RecordsetBetaPQSUnique, $icbs) or die(mysql_error());
$row_RecordsetBetaPQSUnique = mysql_fetch_assoc($RecordsetBetaPQSUnique);
$totalRows_RecordsetBetaPQSUnique = mysql_num_rows($RecordsetBetaPQSUnique);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetBetaPQSRedundant = "SELECT sum(pqs_redundant) as sumBetaPQSRedundant FROM icbs WHERE single_bb_only = '0' AND code_pqs IS NOT NULL AND pqs_redundant = '1'";
$RecordsetBetaPQSRedundant = mysql_query($query_RecordsetBetaPQSRedundant, $icbs) or die(mysql_error());
$row_RecordsetBetaPQSRedundant = mysql_fetch_assoc($RecordsetBetaPQSRedundant);
$totalRows_RecordsetBetaPQSRedundant = mysql_num_rows($RecordsetBetaPQSRedundant);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetScannedPDBNonMember = "SELECT icbs_code FROM non_icbs WHERE length(icbs_code) = '4';";
$RecordsetScannedPDBNonMember = mysql_query($query_RecordsetScannedPDBNonMember, $icbs) or die(mysql_error());
$row_RecordsetScannedPDBNonMember = mysql_fetch_assoc($RecordsetScannedPDBNonMember);
$totalRows_RecordsetScannedPDBNonMember = mysql_num_rows($RecordsetScannedPDBNonMember);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetPDBScannedMember = "SELECT code_icbs FROM icbs WHERE length(code_icbs) = '4';";
$RecordsetPDBScannedMember = mysql_query($query_RecordsetPDBScannedMember, $icbs) or die(mysql_error());
$row_RecordsetPDBScannedMember = mysql_fetch_assoc($RecordsetPDBScannedMember);
$totalRows_RecordsetPDBScannedMember = mysql_num_rows($RecordsetPDBScannedMember);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetScannedPQSMember = "SELECT DISTINCT code_icbs FROM icbs WHERE length(code_icbs) = '6';";
$RecordsetScannedPQSMember = mysql_query($query_RecordsetScannedPQSMember, $icbs) or die(mysql_error());
$row_RecordsetScannedPQSMember = mysql_fetch_assoc($RecordsetScannedPQSMember);
$totalRows_RecordsetScannedPQSMember = mysql_num_rows($RecordsetScannedPQSMember);

mysql_select_db($database_icbs, $icbs);
$query_RecordsetScannedPQSNonMember = "SELECT DISTINCT icbs_code FROM non_icbs WHERE length(icbs_code) = '6';";
$RecordsetScannedPQSNonMember = mysql_query($query_RecordsetScannedPQSNonMember, $icbs) or die(mysql_error());
$row_RecordsetScannedPQSNonMember = mysql_fetch_assoc($RecordsetScannedPQSNonMember);
$totalRows_RecordsetScannedPQSNonMember = mysql_num_rows($RecordsetScannedPQSNonMember);


?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>ICBS - Statistics</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="icbs.css" rel="stylesheet" type="text/css">
</head>

<body class="background">
	<div id="header">
		<TABLE WIDTH="100%" CELLSPACING="10" CELLPADDING="10" summary="site navigation">
		<TR> 
		    <TD width="50%" class="title">ICBS - Statistics</TD>
			<?php include("table.inc");?>
		</TR>
		</TABLE>
		<HR />
	</div>
	
	<div id="content">
		<p>Last database update: <?php echo $row_RecordsetDate['endDate']; ?></p>
		<p>&nbsp;</p>
		<table width="100%" border="1" cellspacing="0" bordercolor="#000000" summary="statistics">
		  <tr> 
		    <td rowspan="2" bordercolor="#000000">Number of ICBS entries by source and 
		      type</td>
		    <td rowspan="2" valign="top" bordercolor="#000000" class="columnPDB"> <div align="center">PDB</div></td>
		    <td colspan="3" bordercolor="#000000" class="columnPQS"> <div align="center">PQS</div></td>
		    <td colspan="2" bordercolor="#000000" class="columnTotal"> <div align="center">Total</div></td>
		  </tr>
		  <tr> 
		    <td bordercolor="#000000" class="columnPQS"> <div align="center">unique</div></td>
		    <td bordercolor="#000000" class="columnPQS"> <div align="center">redundant</div></td>
		    <td bordercolor="#000000" class="columnPQS"> <div align="center">total</div></td>
		    <td bordercolor="#000000" class="columnTotal"> <div align="center">unique</div></td>
		    <td bordercolor="#000000" class="columnTotal"> <div align="center">all</div></td>
		  </tr>
		  <tr> 
		    <td bordercolor="#000000">Single-bridges only</td>
		    <td bordercolor="#000000"><div align="right"><?php echo $row_RecordsetSbPDB['sumSbPDB']; ?></div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $row_RecordsetSbPQSUnique['sumSbPQSUnique']; ?></div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $row_Recordset1SbPQSRedundant['sumSbPQSRedundant']; ?></div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $row_RecordsetSbPQSUnique['sumSbPQSUnique'] + $row_Recordset1SbPQSRedundant['sumSbPQSRedundant']; ?></div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $TotalUniqueSb = $row_RecordsetSbPDB['sumSbPDB'] + $row_RecordsetSbPQSUnique['sumSbPQSUnique']; ?> 
		      </div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $TotalAllSb = $row_RecordsetSbPDB['sumSbPDB'] + $row_RecordsetSbPQSUnique['sumSbPQSUnique']+ $row_Recordset1SbPQSRedundant['sumSbPQSRedundant']; ?> 
		      </div></td>
		  </tr>
		  <tr> 
		    <td bordercolor="#000000">Beta-sheets</td>
		    <td bordercolor="#000000"><div align="right"><?php echo $totalRows_RecordsetBetaPDB; ?></div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $totalRows_RecordsetBetaPQSUnique; ?> </div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $row_RecordsetBetaPQSRedundant['sumBetaPQSRedundant']; ?></div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $totalRows_RecordsetBetaPQSUnique + $row_RecordsetBetaPQSRedundant['sumBetaPQSRedundant']; ?></div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $TotalUniqueBeta = $totalRows_RecordsetBetaPDB + $totalRows_RecordsetBetaPQSUnique; ?> 
		      </div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $TotalAllBeta = $totalRows_RecordsetBetaPDB + $totalRows_RecordsetBetaPQSUnique + $row_RecordsetBetaPQSRedundant['sumBetaPQSRedundant']; ?> 
		      </div></td>
		  </tr>
		  <tr> 
		    <td bordercolor="#000000"><strong>Total hits</strong></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php echo $TotalHitsPDB = $totalRows_RecordsetBetaPDB + $row_RecordsetSbPDB['sumSbPDB']; ?> 
		        </strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php echo $totalRows_RecordsetBetaPQSUnique + $row_RecordsetSbPQSUnique['sumSbPQSUnique']; ?></strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php echo $row_Recordset1SbPQSRedundant['sumSbPQSRedundant'] + $row_RecordsetBetaPQSRedundant['sumBetaPQSRedundant']; ?></strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php echo $TotalHitsPQS = $row_RecordsetSbPQSUnique['sumSbPQSUnique'] + $row_Recordset1SbPQSRedundant['sumSbPQSRedundant'] + $totalRows_RecordsetBetaPQSUnique + $row_RecordsetBetaPQSRedundant['sumBetaPQSRedundant']; ?> 
		        </strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php echo $TotalUniqueSb + $TotalUniqueBeta; ?> 
		        </strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php echo $TotalHits = $TotalAllSb + $TotalAllBeta; ?> 
		        </strong></div></td>
		  </tr>
		  <tr> 
		    <td bordercolor="#000000">total scanned structures</td>
		    <td bordercolor="#000000"><div align="right"><?php echo $TotalScannedPDB = $totalRows_RecordsetScannedPDBNonMember + $totalRows_RecordsetPDBScannedMember ;?> 
		      </div></td>
		    <td bordercolor="#000000"><div align="right">&nbsp;</div></td>
		    <td bordercolor="#000000"><div align="right">&nbsp;</div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $TotalScannedPQS = $totalRows_RecordsetScannedPQSMember + $totalRows_RecordsetScannedPQSNonMember ; ?> 
		      </div></td>
		    <td bordercolor="#000000"><div align="right">&nbsp;</div></td>
		    <td bordercolor="#000000"><div align="right"><?php echo $TotalAll = $TotalScannedPDB + $TotalScannedPQS; ?> 
		      </div></td>
		  </tr>
		  <tr> 
		    <td bordercolor="#000000"><strong>Percentage of structures with ICBS</strong></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php $PercentPDB = $TotalHitsPDB / $TotalScannedPDB * 100; printf("%01.1f", $PercentPDB); ?>%</strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong>&nbsp;</strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong>&nbsp;</strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php $PercentPQS = $TotalHitsPQS / $TotalScannedPQS * 100; printf("%01.1f", $PercentPQS); ?>%</strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong>&nbsp;</strong></div></td>
		    <td bordercolor="#000000"><div align="right"><strong><?php $PercentTotal = $TotalHits / $TotalAll * 100; printf("%01.1f", $PercentTotal); ?>%</strong></div></td>
		  </tr>
		</table>
	</div>
</body>
</html>
<?php
mysql_free_result($RecordsetSbPDB);

mysql_free_result($RecordsetSbPQSUnique);

mysql_free_result($Recordset1SbPQSRedundant);

mysql_free_result($RecordsetBetaPDB);

mysql_free_result($RecordsetBetaPQSUnique);

mysql_free_result($RecordsetBetaPQSRedundant);

mysql_free_result($RecordsetScannedPDBNonMember);

mysql_free_result($RecordsetPDBScannedMember);
?> 
    <?php
mysql_free_result($RecordsetScannedPQSMember);

mysql_free_result($RecordsetScannedPQSNonMember);
?>