New Search. Back to Hitlist
ID_DNA]))
{ $LabNumber[$row->ID_DNA] .= ";"; }
else { $LabNumber[$row->ID_DNA] = ""; }
$tmp = $row->LabNumber;
$LabNumber[$row->ID_DNA] .= $tmp;
}
$result4 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dnabanknumbers.ID_DNA, " .
" amplifications.GenBankNumber AS GenBankNumber, " .
" amplifications.Link AS Link, " .
" geneticlocus.GeneticLocus AS GeneticLocus " .
" FROM dnabanknumbers " .
" LEFT JOIN amplifications ON dnabanknumbers.ID_DNA = amplifications.FK_DNA " .
" LEFT JOIN geneticlocus ON amplifications.FK_GeneticLocus = geneticlocus.ID_GeneticLocus " .
" WHERE amplifications.FK_DNA = '$ID_DNA' " .
" ORDER BY amplifications.ID_Amplification");
$result5 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dnabanknumbers.ID_DNA, " .
" location_stock.Origin_Quantity AS Location_Volume, " .
" location_stock.Rest_Quantity AS Location_Rest, " .
" location_stock.Stock_Barcode AS Stock_Barcode, " .
" location_stock.Stock_Position AS Stock_Position, " .
" location_stock.Fk_Stock_Box AS Location_Box, " .
" location_stock.FK_Stock_Rack AS Location_Rack, " .
" location_stock.Fk_Stock_Fridge AS Location_Fridge " .
" FROM dnabanknumbers " .
" LEFT JOIN location_stock ON dnabanknumbers.FK_Location_Stock = location_stock.ID_Location_Stock " .
" WHERE dnabanknumbers.ID_DNA = '$ID_DNA'");
while($row = mysqli_fetch_object($result5))
{ $Stock_Box = $row->Location_Box;
$Stock_Rack = $row->Location_Rack;
$Stock_Fridge = $row->Location_Fridge;
$Stock_Source_Volume = $row->Location_Volume;
$Stock_Rest_Volume = $row->Location_Rest;
$Stock_Barcode = $row->Stock_Barcode;
$Stock_Position = $row->Stock_Position;}
$result7 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dnabanknumbers.ID_DNA, " .
" aliquots_box.Aliquots_Box AS Aliquots_Box, " .
" aliquots_rack.Aliquots_Rack AS Aliquots_Rack, " .
" aliquots_fridge.Aliquots_Fridge AS Aliquots_Fridge, " .
" aliquots.Aliquot_Number AS Aliquot_Number, " .
" aliquots.Origin_Quantity AS Aliquot_Origin, " .
" aliquots.Rest_Quantity AS Aliquot_Rest, " .
" aliquots.Aliquot_Position AS Aliquot_Position, " .
" aliquots.Aliquot_Barcode AS Aliquot_Barcode, " .
" aliquots.ID_Aliquots " .
" FROM dnabanknumbers " .
" LEFT JOIN aliquots ON dnabanknumbers.ID_DNA = aliquots.FK_DNA " .
" LEFT JOIN aliquots_box ON aliquots_box.ID_Aliquots_Box = aliquots.FK_Aliquots_Box " .
" LEFT JOIN aliquots_rack ON aliquots_rack.ID_Aliquots_Rack = aliquots.FK_Aliquots_Rack " .
" LEFT JOIN aliquots_fridge ON aliquots_fridge.ID_Aliquots_Fridge = aliquots.FK_Aliquots_Fridge " .
" WHERE dnabanknumbers.ID_DNA = '$ID_DNA'");
$result8 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dnabanknumbers.ID_DNA AS ID_DNA, " .
" dnabanknumbers.FK_Cache, " .
" cachecollection.ID_Cache, " .
" cachetaxonidentified.NameAuthorYear AS NameAuthorYear, " .
" cachetaxonidentified.PreferredFlag AS PreferredFlag " .
" FROM cachecollection, cachetaxonidentified, dnabanknumbers " .
" WHERE cachetaxonidentified.FK_Cache = cachecollection.ID_Cache " .
" AND cachecollection.ID_Cache = dnabanknumbers.FK_Cache " .
" AND dnabanknumbers.ID_DNA = $ID_DNA");
while($row = mysqli_fetch_object($result8))
{
$NameAuthorYear[] = $row->NameAuthorYear;
$PreferredFlag[] = $row->PreferredFlag; }
$result9 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dnabanknumbers.ID_DNA AS ID_DNA, " .
" dnabanknumbers.FK_Cache, " .
" cachecollection.ID_Cache, " .
" cachetaxonidentified.ID_TaxonIdentified, " .
" cachehighertaxa.HigherTaxon AS HigherTaxon, " .
" cachehighertaxa.TaxonRank AS TaxonRank " .
" FROM cachecollection, cachetaxonidentified, cachehighertaxa, dnabanknumbers " .
" WHERE cachehighertaxa.FK_CacheTaxonIdentified = cachetaxonidentified.ID_TaxonIdentified " .
" AND cachetaxonidentified.FK_Cache = cachecollection.ID_Cache " .
" AND cachecollection.ID_Cache = dnabanknumbers.FK_Cache " .
" AND dnabanknumbers.ID_DNA = $ID_DNA");
while($row = mysqli_fetch_object($result9))
{
$HigherTaxon[] = $row->HigherTaxon;
$TaxonRank[] = $row->TaxonRank; }
while($row = mysqli_fetch_object($result1))
{
$Relation = $row->FK_Relation;
$ID_Cache = $row->FK_Cache;
$Type = $row->FK_Type;
$Preservation = $row->FK_Preservation;
$Tissue = $row->FK_Tissue;
$ExtractionMethod = $row->FK_Extraction_Method;
$ExtractionStaff = $row->FK_Extraction_Staff;
$DNA_Bank_Number = $row->Dna_Bank_Number;
$Extraction_Date = substr($row->Extraction_Date, 0, -9);
$NoExtractDate = $row->NoExtractDate;
$Absorbance230 = $row->Absorbance230;
$Absorbance280 = $row->Absorbance280;
$Concentration = $row->Concentration;
$Purification_Method = $row->FK_Purification_Method;
$Degradation = $row->FK_Degradation;
$Check_Date = substr($row->Quality_Check_Date, 0, -9);
$Number_Aliquots = $row->Number_Aliquots;
$Quantity_All_Aliquots = $row->Quantity_All_Aliquots;
$Blocked_Until = substr($row->Blocked_Until, 0, -9);
$Blocked_For_Loaning = $row->Blocked_For_Loaning;
$Blocked_For_Publishing = $row->Blocked_For_Publishing;
$Loan_Conditions = $row->Loan_Conditions;
$Notes = $row->Notes;
$Notes_Intern = $row->Notes_Intern;
$Block_General = $row->Block_General;
$Source_Gone = $row->Source_Gone;
$Stock_Gone = $row->Stock_Gone;
$Backup = $row->Backup_Aliquot;
$AcquiredFrom = $row->AcquiredFrom;
$GelFileURI = $row->FileURI;
$GelRemarks = $row->GelRemarks;
$GelVoltage = $row->GelVoltage;
$GelConcentration = $row->GelConcentration;
$GelLadder = $row->GelLadder;
$GelDuration = $row->GelDuration;
/********************************************************************************************
* building table for specimen cache data *
* START *
*********************************************************************************************/
echo "",
"Specimen details (voucher) Specimen Number/UnitID " . $row->UnitID_Specimen . " Specimen database " . $row->SpecimenDatabase . " Collection Code " . $row->CollectionCode_Specimen . " Institution Code " . $row->InstitutionCode_Specimen . " Identifications Taxon Name ";
if($NameAuthorYear) {
foreach($NameAuthorYear as $index => $NameAuthorYearTest)
{
echo $NameAuthorYearTest;
if($PreferredFlag[$index] == '1' or $PreferredFlag[$index] == 'true') { echo " (Preferred Name)"; }
echo " Higher Taxon "; }
else { echo " Higher Taxon "; }
if($HigherTaxon) {
foreach($HigherTaxon as $HigherTaxonTest)
{
echo $HigherTaxonTest . " ";
foreach($TaxonRank as $TaxonRankTest)
{
echo $TaxonRankTest . " Collection Info ",
$row->CountryName ? "Country " . $row->CountryName . " " : "",
$row->CountryISO2 ? "Country ISO Code " . $row->CountryISO2 . " " : "",
" ",
"",
$row->ContinentOrOcean ? "Continent/Ocean " . $row->ContinentOrOcean . " " : "",
$row->Locality ? "Locality " . $row->Locality . " " : "",
" ",
"",
$row->Longitude || $row->Latitude ? "Long | Lat " . $row->Longitude . " | ".$row->Latitude." " : "",
$row->Altitude ? "Altitude " . $row->Altitude . " " : "",
" ",
"",
$row->Collectors ? "Collector(s) " . $row->Collectors . " " : "",
$row->CollectionDate ? "Collection Date " . $row->CollectionDate . " " : "",
" ",
"",
$row->CollectorsNo ? "Collectors' Number " . $row->CollectorsNo . " " : "",
$row->CollectionInfo_Other ? "Collection " . $row->CollectionInfo_Other . " " : "",
" ",
$MultimediaLink ? "Multimedia " . $MultimediaLink . " Type Status " . $row->TypeStatus . "
";
/********************************************************************************************
* building table for specimen cache data *
* END *
*********************************************************************************************/
/********************************************************************************************
* change reference to the voucher *
* START *
*********************************************************************************************/
?>
change reference to voucher
";
/**
* calling Ajax.html for getting last entered DNA number
*/
include ("../ajax/Ajax.html");
?>
