<?php

$DNATemplate = $_GET['DNATemplate'];

$result1 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dnabanknumbers.ID_DNA, " .
         "       dnabanknumbers.Extraction_Date, " .
         "       dnabanknumbers.Quality_Check_Date, " .
         "       dnabanknumbers.Blocked_Until, " .
         "       dnabanknumbers.Blocked_For_Publishing, " .
		 "       dnabanknumbers.Blocked_For_Loaning, " .
         "       dnabanknumbers.Notes, " .
         "       dnabanknumbers.Notes_Intern, " .
         "       dnabanknumbers.Backup_Aliquot, " .
         "       dnabanknumbers.FK_RelationDNA_Voucher, " . 
         "       dnabanknumbers.FK_Type, " .
         "       dnabanknumbers.FK_Preservation, " .
         "       dnabanknumbers.FK_Tissue, " .
         "       dnabanknumbers.FK_Extraction_Method, " .
         "       dnabanknumbers.FK_Extraction_Staff, " .
         "       dnabanknumbers.FK_Purification_Method, " .
         "       dnabanknumbers.FK_Degradation, " .
         "       dnabanknumbers.FK_Provided_By_People AS ProvidedBy " .
         "  FROM dnabanknumbers " .
         " WHERE dnabanknumbers.ID_DNA = '$DNATemplate'");
		 
         
while($row = mysqli_fetch_object($result1)) 
      {      
    $Relation = $row->FK_RelationDNA_Voucher;
    $Type = $row->FK_Type;
    $Preservation = $row->FK_Preservation;
    $Tissue = $row->FK_Tissue;
    $ExtractionMethod = $row->FK_Extraction_Method;
    $ExtractionStaff = $row->FK_Extraction_Staff;
    $Extraction_Date = substr($row->Extraction_Date, 0, -9);
    if($Extraction_Date == "0000-00-00") { $Extraction_Date = "YYYY-MM-DD"; }
    $Degradation = $row->FK_Degradation;
    $Check_Date = substr($row->Quality_Check_Date, 0, -9);
    if($Check_Date == "0000-00-00") { $Check_Date = "YYYY-MM-DD"; }    
    $Blocked_Until = substr($row->Blocked_Until, 0, -9);
    if($Blocked_Until == "0000-00-00") { $Blocked_Until = "YYYY-MM-DD"; }    
    $Notes = $row->Notes;
    $Notes_Intern = $row->Notes_Intern;
    $Blocked_For_Publishing = $row->Blocked_For_Publishing;
	$Blocked_For_Loaning = $row->Blocked_For_Loaning;
    $Backup = $row->Backup_Aliquot;
    $ProvidedBy = $row->ProvidedBy;    }
	
$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 = '$DNATemplate' " .
         " 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 = '$DNATemplate'");
         
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 = '$DNATemplate'");	

?>