<?php
/*-- Add References (related to specimen/observation---------------------#
#                                                                        #
#                                                                        #
#                                                                        #
#-----------------------------------------------------------------------*/

  if($result1)
  {

   if($sqlVoucherRefText1 != "") {
   
   $sql1 = "SELECT * from reference WHERE ReferenceText = '$sqlVoucherRefText1'";
   $result1 = mysqli_query($GLOBALS["___mysqli_ston"], $sql1);
   while($row = mysqli_fetch_object($result1))
   { $ID_Ref1 = $row->ID_References; }
   if($ID_Ref1 == "" or !isset($ID_Ref1)) { $sqlNewRef1 = "INSERT INTO reference (ReferenceText, Created_Who)" .
                            "VALUES ('$sqlVoucherRefText1','$log')";
						$resultNewRef1 = mysqli_query($GLOBALS["___mysqli_ston"], $sqlNewRef1); 
  
   $ID_Ref1 = ((is_null($___mysqli_res = mysqli_insert_id($GLOBALS["___mysqli_ston"]))) ? false : $___mysqli_res); }
		 

   $sqlRef1 = "INSERT INTO sptoolreferences (FK_Collection, FK_References, ReferenceDetail, Created_Who)" .
                            "VALUES ('$IDsptoolCollection','$ID_Ref1','$sqlVoucherRefDetail1','$log')";

   $resultRef1 = mysqli_query($GLOBALS["___mysqli_ston"], $sqlRef1); 
   
   #######################################Error Ref1###############################################################

if(!$resultRef1)
{ $msg = $sqlRef1."\n";
  $msg .= "####Error Ref1####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  include ("../config/Errorreport.php");   
  } 
  ################################################################################################################ 
  }
  
  if($sqlVoucherRefText2 != "") {
    
   $sql2 = "SELECT * from reference WHERE ReferenceText = '$sqlVoucherRefText2'";
   $result2 = mysqli_query($GLOBALS["___mysqli_ston"], $sql2);
   while($row = mysqli_fetch_object($result2))
   { $ID_Ref2 = $row->ID_References; }	
   if($ID_Ref2 == "" or !isset($ID_Ref2)) { $sqlNewRef2 = "INSERT INTO reference (ReferenceText, Created_Who)" .
                            "VALUES ('$sqlVoucherRefText2','$log')";
						$resultNewRef2 = mysqli_query($GLOBALS["___mysqli_ston"], $sqlNewRef2); 
  
   $ID_Ref2 = ((is_null($___mysqli_res = mysqli_insert_id($GLOBALS["___mysqli_ston"]))) ? false : $___mysqli_res); }
		 

   $sqlRef2 = "INSERT INTO sptoolreferences (FK_Collection, FK_References, ReferenceDetail, Created_Who)" .
                            "VALUES ('$IDsptoolCollection','$ID_Ref2','$sqlVoucherRefDetail2','$log')";

   $resultRef2 = mysqli_query($GLOBALS["___mysqli_ston"], $sqlRef2); 
   
   #######################################Error Ref2###############################################################

if(!$resultRef2)
{ $msg = $sqlRef2."\n";
  $msg .= "####Error Ref2####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  include ("../config/Errorreport.php");   
  } 
  ################################################################################################################ 
       }
    
   if($sqlVoucherRefText3 != "") {
     
   $sql3 = "SELECT * from reference WHERE ReferenceText = '$sqlVoucherRefText3'";
   $result3 = mysqli_query($GLOBALS["___mysqli_ston"], $sql3);
   while($row = mysqli_fetch_object($result3))
   { $ID_Ref3 = $row->ID_References; }		 
   if($ID_Ref3 == "" or !isset($ID_Ref3)) { $sqlNewRef3 = "INSERT INTO reference (ReferenceText, Created_Who)" .
                            "VALUES ('$sqlVoucherRefText3','$log')";
						$resultNewRef3 = mysqli_query($GLOBALS["___mysqli_ston"], $sqlNewRef3); 
  
   $ID_Ref3 = ((is_null($___mysqli_res = mysqli_insert_id($GLOBALS["___mysqli_ston"]))) ? false : $___mysqli_res); }
		 

   $sqlRef3 = "INSERT INTO sptoolreferences (FK_Collection, FK_References, ReferenceDetail, Created_Who)" .
                            "VALUES ('$IDsptoolCollection','$ID_Ref3','$sqlVoucherRefDetail3','$log')";

   $resultRef3 = mysqli_query($GLOBALS["___mysqli_ston"], $sqlRef3); 
   
   #######################################Error Ref1###############################################################

if(!$resultRef3)
{ $msg = $sqlRef3."\n";
  $msg .= "####Error Ref1####";
  if($debug == '1') echo $msg;
  trigger_error($msg, E_USER_ERROR);
  include ("../config/Errorreport.php");   
  } 
  ################################################################################################################ 
       }     
       

}

?>