" target="_blank"> |
|
|
|
|
';
$sql = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.Blocked != 'Yes' AND sptoolcollection.Protected != 'Yes' and sptoolcollection.Permission != 'No' and sptoolcollection.FK_BasisOfRecord = '1'";
$result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql)) { $countspecimens = mysqli_num_rows($result);}
$sql = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.Blocked != 'Yes' AND sptoolcollection.Protected != 'Yes' and sptoolcollection.Permission != 'No' and sptoolcollection.FK_BasisOfRecord = '6'";
$result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql)) { $countsamples = mysqli_num_rows($result);}
$sql2 = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.Blocked != 'Yes' AND sptoolcollection.Protected != 'Yes' and sptoolcollection.Permission != 'No' and sptoolcollection.FK_BasisOfRecord = '2'";
$result2 = mysqli_query($GLOBALS["___mysqli_ston"], $sql2);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql2)) { $countobservations = mysqli_num_rows($result2);}
$sql3 = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.Blocked != 'Yes' AND sptoolcollection.Protected != 'Yes' and sptoolcollection.Permission != 'No' and sptoolcollection.FK_BasisOfRecord = '3'";
$result3 = mysqli_query($GLOBALS["___mysqli_ston"], $sql3);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql3)) { $countliving = mysqli_num_rows($result3);}
$sql4 = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.Blocked != 'Yes' AND sptoolcollection.Protected != 'Yes' and sptoolcollection.Permission != 'No' and sptoolcollection.FK_BasisOfRecord = '4'";
$result4 = mysqli_query($GLOBALS["___mysqli_ston"], $sql4);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql4)) { $countgerm = mysqli_num_rows($result4);}
$sql5 = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.Blocked != 'Yes' AND sptoolcollection.Protected != 'Yes' and sptoolcollection.Permission != 'No' and sptoolcollection.FK_BasisOfRecord = '5'";
$result5 = mysqli_query($GLOBALS["___mysqli_ston"], $sql5);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql5)) { $countfossils = mysqli_num_rows($result5);}
$sqltaxa = "SELECT ID_TaxonIdentified FROM sptooltaxa LEFt JOIN sptoolcollection ON sptooltaxa.FK_Collection = sptoolcollection.ID_Collection WHERE sptoolcollection.Blocked != 'Yes' AND sptoolcollection.Protected != 'Yes' and sptoolcollection.Permission != 'No' GROUP BY sptooltaxa.NameAuthorYear";
$resulttaxa = mysqli_query($GLOBALS["___mysqli_ston"], $sqltaxa);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sqltaxa)) { $counttaxa = mysqli_num_rows($resulttaxa);}
echo "| Summary | ";
echo "| Total preserved specimens | ".$countspecimens." | ";
echo "| Total material samples | ".$countsamples." | ";
echo "| Total observations | ".$countobservations." | ";
echo "| Total living specimens | ".$countliving." | ";
echo "| Total fossils | ".$countfossils." | ";
echo "| Total germplasm records | ".$countgerm." | ";
echo "| Total taxa | ".$counttaxa." |
| ";
}
if ((isset($_SESSION['management']) || $_SESSION['management'] || isset($_SESSION['admin']) || $_SESSION['admin']) && $log != "") {
echo '
 |
|
';
$sql = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.FK_BasisOfRecord = '1'";
$result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql)) { $countspecimens = mysqli_num_rows($result);}
$sql = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.FK_BasisOfRecord = '6'";
$result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql)) { $countsamples = mysqli_num_rows($result);}
$sql2 = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.FK_BasisOfRecord = '2'";
$result2 = mysqli_query($GLOBALS["___mysqli_ston"], $sql2);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql2)) { $countobservations = mysqli_num_rows($result2);}
$sql3 = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.FK_BasisOfRecord = '3'";
$result3 = mysqli_query($GLOBALS["___mysqli_ston"], $sql3);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql3)) { $countliving = mysqli_num_rows($result3);}
$sql4 = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.FK_BasisOfRecord = '4'";
$result4 = mysqli_query($GLOBALS["___mysqli_ston"], $sql4);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql4)) { $countgerm = mysqli_num_rows($result4);}
$sql5 = "SELECT ID_Collection FROM sptoolcollection WHERE sptoolcollection.FK_BasisOfRecord = '5'";
$result5 = mysqli_query($GLOBALS["___mysqli_ston"], $sql5);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sql5)) { $countfossils = mysqli_num_rows($result5);}
$sqltaxa = "SELECT ID_TaxonIdentified FROM sptooltaxa LEFt JOIN sptoolcollection ON sptooltaxa.FK_Collection = sptoolcollection.ID_Collection GROUP BY sptooltaxa.NameAuthorYear";
$resulttaxa = mysqli_query($GLOBALS["___mysqli_ston"], $sqltaxa);
if(mysqli_query($GLOBALS["___mysqli_ston"], $sqltaxa)) { $counttaxa = mysqli_num_rows($resulttaxa);}
echo "| Summary | ";
echo "| Total preserved specimens | ".$countspecimens." | ";
echo "| Total material samples | ".$countsamples." | ";
echo "| Total observations | ".$countobservations." | ";
echo "| Total living specimens | ".$countliving." | ";
echo "| Total fossils | ".$countfossils." | ";
echo "| Total germplasm records | ".$countgerm." | ";
echo "| Total taxa | ".$counttaxa." |
| ";
}
if((isset($_SESSION['project']) || $_SESSION['project']) && $log != "") { ?>
|
|
|
| Summary | ";
echo "| Total preserved specimens | ".$countspecimens." | ";
echo "| Total samples | ".$countsamples." | ";
echo "| Total observations | ".$countobservations." | ";
echo "| Total living specimens | ".$countliving." | ";
echo "| Total fossils | ".$countfossils." | ";
echo "| Total germplasm records | ".$countgerm." | ";
echo "| Total taxa | ".$counttaxa." |
| ";
} ?>
|