<?php
/**
* Save new DNA data
* <br/><br/>
* there are two ways of saving a new record
* <br/><br/>
* 1. hit "Save" button and the input form will be empty after saving
* <br/><br/>
* 2. hit "Save+Copy" an the input form will display last entries, which is quite comfortable when entering a series of records
* <br/><br/>
* Access to all user except of guests
* @author Gabriele Droege, DNA Bank Network <contact@dnabank-network.org>
* @version 2.0
* @package Input
* @copyright Copyright © 2011 DNA Bank Network http://www.dnabank-network.org<br>The contents of this file are subject to the Mozilla Public License Version 1.1
* @filesource
* @license http://www.mozilla.org/MPL/ MPL
*/

if($formSubmitSave or $formSubmitCopy)
{
    /********************************************************************************************
    * some data quality checks first                                                            *
    * START                                                                                     *
    *********************************************************************************************/

if(empty($formDnaBankNumber) or ($formDnaBankNumber == $Prefix)) { echo '<span class="error">Please define a DNA Extraction Number!</span>'; 
$Validation = "FALSE"; }


//else {

 if(!empty($formDnaBankNumber) and $formDnaBankNumber != $Prefix)
 {       

 if($formExtractionDate == "YYYY-MM-DD") { unset($formExtractionDate); }
else { $date = $formExtractionDate;
if (!valiDate($date)) {  
$Validation = "FALSE";
echo '<span class="error">Extraction date incorrect!</span><br>';  }
else { $ExtractionDate = $formExtractionDate; } }

if($formCheckDate == "YYYY-MM-DD" or $formCheckDate == "") { unset($formCheckDate); }
else { $date = $formCheckDate;
if (!valiDate($date)) {  
$Validation = "FALSE";
echo '<span class="error">Quality check date incorrect!</span><br>';  }
else { $CheckDate = $formCheckDate; } }

if($formBlockDate == "YYYY-MM-DD" or $formBlockDate == "") { unset($formBlockDate); }
else { $date = $formBlockDate;
if (!valiDate($date)) {  
$Validation = "FALSE";
echo '<span class="error">Block date incorrect!</span><br>';  }
else { $BlockDate = $formBlockDate; } }

if(empty($formRelation)) { 
$Validation = "FALSE";
echo '<span class="error">Please define relation to voucher!</span><br>';  }

if((empty($formExtractionDate) or $formExtractionDate == "YYYY-MM-DD") and empty($formNoExtractDate)) { 
$Validation = "FALSE";
echo '<span class="error">Please enter extraction date or select checkbox!</span><br>';  }

if(empty($formExtractionMethod)) { 
$Validation = "FALSE";
echo '<span class="error">Please select extraction method!</span><br>';  }

if(empty($formExtractionStaff)) { 
$Validation = "FALSE";
echo '<span class="error">Please select extraction staff!</span><br>';  }

if(empty($formProviderIntern) and empty($formProviderExtern) and !empty($formSpecimenNumber))
{
unset($formProviderIntern);
unset($formProviderExtern); 
echo '<span class="error">Please select a Specimen database!</span>'; 
$Validation = "FALSE";
}
if(!empty($formProviderIntern) and !empty($formProviderExtern))
{
echo '<span class="error">Please select either an "Internal" or "External" Specimen database!</span>'; 
$Validation = "FALSE";}

if(empty($formUnitID))
{ 
echo '<span class="error">Please verify specimen first!</span>'; 
$Validation = "FALSE";}

}
    /********************************************************************************************
    * some data quality checks first                                                            *
    * END                                                                                       *
    *********************************************************************************************/
if(!empty($formDnaBankNumber) and ($formDnaBankNumber != $Prefix) and $Validation != "FALSE") {

$SpecimenNo = urlencode($_POST['formSpecimenNumber']);

    
   /********************************************************************************************
    * saving specimen data                                                                     *
    * START                                                                                    *
    *******************************************************************************************/ 

   $variable1 = $_POST['formUnitID']; 
   $CatalogNoText = $_POST['CatalogNoText']; 
   $variable2 = $_POST['formSourceInstitutionID'];
   $variable3 = $_POST['formSourceID']; 
   $variable4 = $_POST['formProviderExtern'];
   $variable5 = $_POST['formTest'];
   $variable6 = $_POST['formProviderIntern'];
   
   if($variable1 != "" and !$formSubmitVerify)
   {

$mykey = key($variable1);       
 
    if(!empty($variable4))
    {
$result = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dataset.ID_Dataset AS ID_Dataset, " .
 "       schemata.QueryPart1b AS QueryPart1b, " .
 "       schemata.QueryPart1_1 AS QueryPart1_1, " .
 "       schemata.QueryPart1_2b AS QueryPart1_2b, " .
 "       schemata.QueryPart2 AS QueryPart2, " .
 "       schemata.QueryPart3 AS QueryPart3, " .
 "       schemata.QueryPart4 AS QueryPart4, " . 
 "       schemata.QueryPart5 AS QueryPart5, " . 
 "       provider.Provider AS Provider, " .
 "       dataset.Digir_Resource AS Digir_Resource, " .
 "       dataset.Digir_Source AS Digir_Source, " .
 "       provider.Provider AS Provider, " . 
 "       provider.FK_Schema " .
 "  FROM dataset " .
 "  LEFT JOIN provider ON dataset.FK_Provider = provider.ID_Provider " . 
 "  LEFT JOIN schemata ON provider.FK_Schema = schemata.ID_Schema " .
 " WHERE dataset.ID_Dataset = '$variable4'");
}

if(!empty($variable6))
{
$result = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dataset.ID_Dataset AS ID_Dataset, " .
 "       schemata.QueryPart1b AS QueryPart1b, " .
 "       schemata.QueryPart1_1 AS QueryPart1_1, " .
 "       schemata.QueryPart1_2b AS QueryPart1_2b, " .
 "       schemata.QueryPart2 AS QueryPart2, " .
 "       schemata.QueryPart2a AS QueryPart2a, " .
 "       schemata.QueryPart3 AS QueryPart3, " .
 "       schemata.QueryPart4 AS QueryPart4, " . 
 "       schemata.QueryPart5 AS QueryPart5, " . 
 "       provider.Provider AS Provider, " .
 "       dataset.Digir_Resource AS Digir_Resource, " .
 "       dataset.Digir_Source AS Digir_Source, " .
 "       provider.Provider AS Provider, " . 
 "       provider.FK_Schema " .
 "  FROM dataset " .
 "  LEFT JOIN provider ON dataset.FK_Provider = provider.ID_Provider " . 
 "  LEFT JOIN schemata ON provider.FK_Schema = schemata.ID_Schema " .
 " WHERE dataset.ID_Dataset = '$variable6'");
}

if(!empty($formProviderIntern) or !empty($formProviderExtern))
{

while($row = mysqli_fetch_object($result)) 
      {
$ID_Dataset = $row->ID_Dataset;   
$Provider = $row->Provider; 
$QueryPart1b = $row->QueryPart1b;
$QueryPart1_1 = $row->QueryPart1_1;
$QueryPart1_2b = $row->QueryPart1_2b;
$QueryPart2 = $row->QueryPart2;
$QueryPart2a = $row->QueryPart2a;
$QueryPart3 = $row->QueryPart3;
$QueryPart4 = $row->QueryPart4;
$QueryPart5 = $row->QueryPart5;
$Digir_Resource = $row->Digir_Resource;
$Digir_Source = $row->Digir_Source;
$ID_Schema = $row->FK_Schema;
 
}

$SourceUnitID = urlencode($variable1[$mykey]);
$SourceInstitutionCode = urlencode($variable2[$mykey]);
$SourceCode = urlencode($variable3[$mykey]);
$Digir_Resource1 = urlencode($Digir_Resource);
$Digir_Source1 = urlencode($Digir_Source);

}

if($Provider == NULL and $ID_Dataset == "1")
{ include("Save_SpTool.php"); }

if($ID_Dataset == "2")
{ 
include("Save_GBIF.php"); }


else {

if($SpecimenNo != "")
{
if($variable6 != '')
{$test1 = 'true'; }
if($variable4 != '1' and $variable4 != '')
{$test2 = 'true'; }

if($test1 == 'true' or $test2 == 'true')
{
if($ID_Schema == 3 and $CatalogNoText[$mykey] == "True")
{
$file = $Provider.$QueryPart1b.$Digir_Resource1.$QueryPart1_1.$Digir_Source1.$QueryPart1_2b."CatalogNumberText%3E".$SourceUnitID."%3C%2Fdarwin%3ACatalogNumberText".$QueryPart3.$SourceInstitutionCode.$QueryPart4.$SourceCode.$QueryPart5; } 

if($ID_Schema == 3 and $CatalogNoText[$mykey] != "True")
{
$file = $Provider.$QueryPart1b.$Digir_Resource1.$QueryPart1_1.$Digir_Source1.$QueryPart1_2b."CatalogNumber%3E".$SourceUnitID."%3C%2Fdarwin%3ACatalogNumber".$QueryPart3.$SourceInstitutionCode.$QueryPart4.$SourceCode.$QueryPart5; } 

if($ID_Schema != 3) {

$file = $Provider."&query=".urlencode('<?xml version="1.0" encoding="UTF-8"?>
<request xmlns="http://www.biocase.org/schemas/protocol/1.3">
<header><type>search</type></header>
<search><requestFormat>http://www.tdwg.org/schemas/abcd/2.06</requestFormat>
<responseFormat start="0" limit="10">http://www.tdwg.org/schemas/abcd/2.06</responseFormat>
<filter><and><and><like path="/DataSets/DataSet/Units/Unit/UnitID">');
$file .= $SourceUnitID;
$file .= urlencode('</like><like path="/DataSets/DataSet/Units/Unit/SourceInstitutionID">');
$file .= $SourceInstitutionCode;
$file .= urlencode('</like></and><like path="/DataSets/DataSet/Units/Unit/SourceID">');
$file .= $SourceCode;
$file .= urlencode('</like></and></filter><count>false</count></search></request>');

//$file = $Provider.$QueryPart1b.$Digir_Resource1.$QueryPart1_1.$Digir_Source1.$QueryPart1_2b.$SourceUnitID.$QueryPart3.$SourceInstitutionCode.$QueryPart4.$SourceCode.$QueryPart5; 
}
//echo $file;
   $dom = new DOMDocument();
   $dom->Load($file);

if($ID_Schema == 1) {
  /**
  * calling specific script for saving data in ABCD1.2 format
  */
  include ("Save_ABCD1.2.php");}
if($ID_Schema == 2) {
  /**
  * calling specific script for saving data in ABCD2.06 format
  */
  include ("Save_ABCD2.06.php");}
if($ID_Schema == 3 or $ID_Schema == 6) {
  /**
  * calling specific script for saving data in DarwinCore format
  */
  include ("Save_DarwinCore.php");}
if($ID_Schema == 4) {
  /**
  * calling specific script for saving data in ABCD2.05 format
  */
  include ("Save_ABCD2.05.php");}
}

}
} // if($Provider != NULL and $ID_Dataset != "1")

if(empty($formUnitID[0]) and $ID_Dataset != '1')
{ echo "<span class='error'>No hits. Please verify your entry and selection of specimen database. DNA data have not been saved!</span>";}

if($formTest[0] != "")
{ echo "<span class='error'>Please select a specimen or verify your entry!</span>";}
}
if(empty($formTest[0])) {
 
     
     
     $resultExist= mysqli_query($GLOBALS["___mysqli_ston"], "SELECT ID_DNA, Dna_Bank_Number FROM dnabanknumbers " .
                            "WHERE Dna_Bank_Number = '$formDnaBankNumber'");
      if(!mysqli_num_rows($resultExist)) {};
      if(mysqli_num_rows($resultExist))
      
      
       {  
      $Validation = "FALSE";
       echo "<span class='error'>DNA Extraction Number already exist!</span>";
       }
      
 
 if(empty($resultExist) or !mysqli_num_rows($resultExist))   
      {       
      

if($formUnitID != "" or isset($formUnitID))
{
if($formProviderIntern != "" or $formProviderExtern != "")                  
{

  /**
  * include separate script for saving the final specimen data
  */
  include ("Save_Specimen.php");} }

 if($error == "true" or $Specimen_Saved != "true")
    {   $msg = "####Error in Save_Specimen.php; Specimen and DNA record have not been saved.####";
		if($debug == '1') echo $msg;
        trigger_error($msg, E_USER_ERROR);
        /**
        * calling Error message
        */
        include ("../config/Errorreport.php"); }
        
    /*******************************************************************************************
    * saving specimen data                                                                     *
    * END                                                                                      *
    *******************************************************************************************/         
        
else {

   if (isset($_REQUEST['c'])) 
   {
   reset($_REQUEST['c']);
   foreach ($_REQUEST['c'] as $b)
   {
   if ($b == "SourceGone")
   $SourceGone = "1";
   if ($b == "StockGone")
   $StockGone = "1";
   if ($b == "BlockLoan")
   $BlockForLoan = "1";
   if ($b == "BlockPublish")
   $BlockForPublishing = "1";
   if ($b == "Aliquot")
   $Aliquot = "1";
   if ($b == "Backup")
   $Backup = "1";
   }
   }
   
  /**
  * include script to mask data before inserting, e.g. add slashes before additional characters etc.
  */
include("addslashes_dnabanknumbers.php"); 
$GUID = GUID();  


if($formStockFridge != "" or $formStockRack != "" or $formStockBox != "" or $sqlStockQuantity != "" or $sqlStockRest != "" or $formBarcodeStock != "")
{        

         $sql1 = "INSERT INTO location_stock (FK_Stock_Box, FK_Stock_Rack, FK_Stock_Fridge, Origin_Quantity, Rest_Quantity, Stock_Barcode, Stock_Position, Created_Who)" .
                          "VALUES ($formStockBox,$formStockRack,$formStockFridge,'$sqlStockQuantity','$sqlStockRest','$formBarcodeStock','$sqlPositionStock','$log')";
         $result1 =  mysqli_query($GLOBALS["___mysqli_ston"], $sql1);
         $IDLocationStock=((is_null($___mysqli_res = mysqli_insert_id($GLOBALS["___mysqli_ston"]))) ? false : $___mysqli_res);
#######################################Error 1###############################################################

if(!$result1)
{ $msg = $sql1."\n";
  $msg .= "####Error 1####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */
  include ("../config/Errorreport.php");   }
  
#############################################################################################################  
}      

if($formGelFileURI or $formGelVoltage or $formGelConcentration or $formGelRemarks or $formGelDuration or $formGelLadder)
{
  $sqlGel = "INSERT INTO gelimages (FileURI, GelRemarks, GelVoltage, GelConcentration, GelDuration, GelLadder, Created_Who) 
  VALUES ('$sqlGelFileURI','$sqlGelRemarks','$sqlGelVoltage','$sqlGelConcentration','$sqlGelDuration','$sqlGelLadder','$log')";
  $resultGel = mysqli_query($GLOBALS["___mysqli_ston"], $sqlGel);
  $IDGelImage = ((is_null($___mysqli_res = mysqli_insert_id($GLOBALS["___mysqli_ston"]))) ? false : $___mysqli_res);
#######################################Error GelImage########################################################

if(!$resultGel)
{ $msg = $sqlGel."\n";
  $msg .= "####Error GelIimage####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */
  include ("../config/Errorreport.php");   }
  
#############################################################################################################    
	
}

  
     if (!isset($moreGenBank))
{       unset($formGeneticLocusA);
        unset($formGenbankNumberA); 
        unset($formGenbankLinkA);
        unset($formGeneticLocusB);
        unset($formGenbankNumberB); 
        unset($formGenbankLinkB);
        unset($formGeneticLocusC);
        unset($formGenbankNumberC); 
        unset($formGenbankLinkC);
        unset($formGeneticLocusD);
        unset($formGenbankNumberD); 
        unset($formGenbankLinkD);            
        }

      $sql2 = "INSERT INTO dnabanknumbers (Dna_Bank_Number, FK_Relation, FK_Type, " .         
                    "FK_Preservation, FK_Tissue, FK_Extraction_Method, Extraction_Date, NoExtractDate, FK_Extraction_Staff, " .
                    "FK_Purification_Method, Absorbance280, Absorbance230, Concentration, Quality_Check_Date, FK_GelImage, " .
                    "FK_Location_Stock, Stock_Gone, Source_Gone, Blocked_Until, " . 
                    "Blocked_For_Loaning, Blocked_For_Publishing, Loan_Conditions, FK_AcquiredFrom, Notes, Notes_Intern, Backup_Aliquot, GUID, Created_Who, FK_Cache)" .
                    "VALUES ('$sqlDnaBankNumber',$formRelation,$formType,$formPreservation,$formTissue,
                            $formExtractionMethod,$ExtractionDate,'$formNoExtractDate',$formExtractionStaff,
                            $formPurificationMethod,$sqlAbsorbance2802,$sqlAbsorbance2302,$sqlConcentration2,
                            $CheckDate,$IDGelImage,$IDLocationStock,'$StockGone','$SourceGone',
                            $BlockDate,'$BlockedForLoan','$BlockedForPublishing','$sqlLoanConditions',$formAcquiredFrom,'$sqlNotes','$sqlNotesIntern','$Backup','$GUID','$log','$IDTableCache')";
			$result2 = mysqli_query($GLOBALS["___mysqli_ston"], $sql2); 
            $IDDna=((is_null($___mysqli_res = mysqli_insert_id($GLOBALS["___mysqli_ston"]))) ? false : $___mysqli_res); 
            
#######################################Error 2###############################################################

if(!$result2)
{ $msg = $sql2."\n";
  $msg .= "####Error 2####";
  if($debug == '1') echo $msg;
  mail("g.droege@bgbm.org", "Error report", $msg, "From: BGBM-".$_SESSION['log']); 
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */
  include ("../config/Errorreport.php");   }
  
#############################################################################################################  
      if($result2)
       {
	   
	   if($formLabNumbers != "" or isset($formLabNumbers)){
	   
		 $labNumberArray = explode(";", $formLabNumbers);
     while($i = each($labNumberArray))
     {
      $labNumber = trim(addslashes($i[1]));
	   
	   $sql3 = "INSERT INTO labnumber (ID_DNA, LabNumber, Created_Who) VALUES ('$IDDna', '$labNumber', '$log')";
	   $result3 = mysqli_query($GLOBALS["___mysqli_ston"], $sql3);
	   
	   } 
	   #######################################Error 2###############################################################

if(!$result3 and $formLabNumber)
{ $msg = $sql3."\n";
  $msg .= "####Error 3####";
  if($debug == '1') echo $msg;
  mail("g.droege@bgbm.org", "Error report", $msg, "From: BGBM-".$_SESSION['log']); 
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */
  include ("../config/Errorreport.php");   }
  
#############################################################################################################  
	   
	   }
	   

	   include("../config/RecordHasBeenSaved.php"); 
echo "<span class='fine'>Specimen Number: </span>
<span class='error'>".$sqlUnitID."</span><span class='fine'> Institution Code: </span>
<span class='error'>".$sqlSourceInstitutionCode."</span><span class='fine'> Collection Code: </span>
<span class='error'>".$sqlSourceName."</span><br/><span class='fine'> Taxon Name: </span>
<span class='error' align='center'>";
if($View != "") { echo $View; } else { 
if(is_array($sqlNameAuthorYearString)) { echo $sqlNameAuthorYearString[0]; }
	else { echo $sqlNameAuthorYearString; } }
echo "</span><br />";
if ($count == '1')
{ echo "<span class='fine'>".$count." DNA Sample already exist for the selected specimen!</span><br />"; }
if($count > 1)
{ echo "<span class='fine'>".$count." DNA Samples already exist for the selected specimen!</span><br />"; }
	   
	   
	   echo "<span class='fine'>DNA Extraction No: </span><span class='error'>".$formDnaBankNumber."</span>"
	   .build_href_blank("../search/query.php", "sqlType=Detail&ID_DNA=".$IDDna, "Show this record (opens in new tab)")."<br />";  }

 if($formGenBankNumber)
 { 
  $sql = "INSERT INTO amplifications (FK_DNA, FK_GeneticLocus, GenBankNumber, Link, Created_Who)" .
                          "VALUES ('$IDDna','$formGeneticLocus','$sqlGenBankNumber','$sqlGenBankLink','$log')";
  $result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
#######################################Error formGenbankNumber###############################################################

if(!$result)
{ $msg = $sql."\n";
  $msg .= "####Error formGenbankNumber####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */
  include ("../config/Errorreport.php");   }
  
#############################################################################################################                           
 }
 if($formGenBankNumberA)
 {
  $sql = "INSERT INTO amplifications (FK_DNA, FK_GeneticLocus, GenBankNumber, Link, Created_Who)" .
                          "VALUES ('$IDDna','$formGeneticLocusA','$sqlGenBankNumberA','$sqlGenBankLinkA','$log')";
  $result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
                          
#######################################Error formGenbankNumberA###############################################################

if(!$result)
{ $msg = $sql."\n";
  $msg .= "####Error formGenbankNumberA####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */
  include ("../config/Errorreport.php");   }
  
#############################################################################################################                           
 }
 if($formGenBankNumberB)
 {
  $sql = "INSERT INTO amplifications (FK_DNA, FK_GeneticLocus, GenBankNumber, Link, Created_Who)" .
                          "VALUES ('$IDDna','$formGeneticLocusB','$sqlGenBankNumberB','$sqlGenBankLinkB','$log')";
  $result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
                          
#######################################Error formGenbankNumberB###############################################################

if(!$result)
{ $msg = $sql."\n";
  $msg .= "####Error formGenbankNumberB####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */  
  include ("../config/Errorreport.php");   }
  
#############################################################################################################         
 }  
 if($formGenBankNumberC)
 {
  $sql = "INSERT INTO amplifications (FK_DNA, FK_GeneticLocus, GenBankNumber, Link, Created_Who)" .
                          "VALUES ('$IDDna','$formGeneticLocusC','$sqlGenBankNumberC','$sqlGenBankLinkC','$log')";
  $result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
                          
#######################################Error formGenbankNumberC###############################################################

if(!$result)
{ $msg = $sql."\n";
  $msg .= "####Error formGenbankNumberC####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */  
  include ("../config/Errorreport.php");   }
  
#############################################################################################################                           
 }   
 if($formGenBankNumberD)
 {
  $sql = "INSERT INTO amplifications (FK_DNA, FK_GeneticLocus, GenBankNumber, Link, Created_Who)" .
                          "VALUES ('$IDDna','$formGeneticLocusD','$sqlGenBankNumberD','$sqlGenBankLinkD','$log')";
  $result = mysqli_query($GLOBALS["___mysqli_ston"], $sql);
                          
#######################################Error formGenbankNumberD###############################################################

if(!$result)
{ $msg = $sql."\n";
  $msg .= "####Error formGenbankNumberD####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */  
  include ("../config/Errorreport.php");   }
  
#############################################################################################################  
 }     
                
                 
if (isset($_REQUEST['Aliquot']))
{ 
   $letter = B; 
   
foreach ($_POST['x'] as $v => $value)
{
    
     $rack = $_POST['y'][$v];
     
     $box = $_POST['z'][$v];
     
     $SourceQuantity = $AliquotSourceQuantity[$v];
     $RestQuantity = $AliquotRestQuantity[$v];
     $Barcode = $BarcodeAliquot[$v];
     $Position = $PositionAliquot[$v];
     
     $lettercount = $letter++;
     $AliquotNumber = $formDnaBankNumber.'-'.$lettercount; 
       
     if (!isset($_REQUEST['Aliquot']))
     { unset($value);
       unset($rack);
       unset($box); 
       unset($SourceQuantity);   
       unset($RestQuantity);
       unset($Barcode); 
       unset($Position);    }
      
     else {
       
       if($value=="")
     { unset($value);
       unset($rack); 
       unset($box); 
       unset($SourceQuantity);   
       unset($RestQuantity);
       unset($Barcode); 
       unset($Position);  }
       
     else {  
     
     $sql3 = "INSERT INTO aliquots (FK_DNA, FK_Aliquots_Fridge, FK_Aliquots_Rack, FK_Aliquots_Box, 
                   Aliquot_Number, Origin_Quantity, Rest_Quantity, Aliquot_Barcode, Aliquot_Position, Price, Currency, Created_Who) " .
                  "VALUES ('$IDDna','$value','$rack','$box','$AliquotNumber','$SourceQuantity','$RestQuantity','$Barcode','$Position','$priceperaliquot','$Currency','$log')";
     $result3 = mysqli_query($GLOBALS["___mysqli_ston"], $sql3);
                  
#######################################Error sql3###############################################################

if(!$result3)
{ $msg = $sql3."\n";
  $msg .= "####Error sql3####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */  
  include ("../config/Errorreport.php");   }
  
#############################################################################################################  
 }
 }

 } 
  
}

   if(!empty($formAliquotsFridge) or !empty($formAliquotsRack) or !empty($formAliquotsBox))
      {        

      
    $AliquotNumber = $formDnaBankNumber.'-A'; 
        
          $sql4 = "INSERT INTO aliquots (FK_DNA, FK_Aliquots_Fridge, FK_Aliquots_Rack, FK_Aliquots_Box, Aliquot_Number, Origin_Quantity, Rest_Quantity, Aliquot_Barcode, Aliquot_Position, Price, Currency, Created_Who)" .
                          "VALUES ('$IDDna',$formAliquotsFridge,$formAliquotsRack,$formAliquotsBox,'$AliquotNumber','$sqlQuantityAliquot','$sqlAliquotRest','$sqlBarcodeAliquot','$sqlPositionAliquot','$priceperaliquot','$Currency','$log')";
          $result4 = mysqli_query($GLOBALS["___mysqli_ston"], $sql4);

#######################################Error sql4###############################################################

if(!$result4)
{ $msg = $sqlt4."\n";
  $msg .= "####Error sql4####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  /**
  * calling Error message
  */  
  include ("../config/Errorreport.php");   }
  
############################################################################################################# 
     }      
}
}
}
}
//}
}

?>