<?php
if($formSubmitVerify1)
{

$SpecimenNumber = urlencode($_POST['formUnitIDAssoc1']);

if(empty($formProviderAssoc1))
{
echo "<a id='Red'>Please select a Specimen Database!</a>";}

else {

$sql = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dataset.ID_Dataset, " .
 "       dataset.FK_Provider, " .
 "       schemata.QueryPart1, " .
 "       schemata.QueryPart1_1, " .
 "       schemata.QueryPart1_2, " .
 "       schemata.QueryPart2, " .
 "       schemata.QueryPart3, " .
 "       schemata.QueryPart4, " . 
 "       dataset.Digir_Resource, " .
 "       dataset.Digir_Source, " .
 "       provider.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 = '$formProviderAssoc1'");

while($row = mysqli_fetch_object($sql)) 
      {
$ID_Dataset = $row->ID_Dataset;
$ID_Provider = $row->FK_Provider;
$Provider = $row->Provider; 
$QueryPart1 = $row->QueryPart1;
$QueryPart1_1 = $row->QueryPart1_1;
$QueryPart1_2 = $row->QueryPart1_2;
$QueryPart2 = $row->QueryPart2;
$QueryPart2a = $row->QueryPart2a;
$QueryPart3 = $row->QueryPart3;
$QueryPart4 = $row->QueryPart4;
$Digir_Resource = $row->Digir_Resource;
$Digir_Source = $row->Digir_Source;
$ID_Schema = $row->FK_Schema;

}

$Digir_Resource1 = urlencode($Digir_Resource);
$Digir_Source1 = urlencode($Digir_Source);


//if($ID_Dataset == '1' and $ID_Provider == '0')
/*if($ID_Dataset == '1')
{
include ("../sptool/show_cache_data.php");
}*/

//else {

include ("verify.php");

//}
}
}



   $variable1 = $_POST['formUnitID']; 
   $CatalogNoText = $_POST['CatalogNoText']; 
   $variable2 = $_POST['formSourceInstitutionID'];
   $variable3 = $_POST['formSourceID']; 
   $variable4 = $_POST['formProviderExtern'];
   $variable5 = $_POST['formTest'];
   $variable6 = $_POST['formProviderIntern'];

   
   if($variable5 != "" and !$formSubmitVerify1 and !$formSubmitSave)
   {

$mykey = key($variable5);   

if(!empty($variable4))
{   
$sql = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dataset.ID_Dataset AS ID_Dataset, " .
 "       schema.QueryPart1b AS QueryPart1b, " .
 "       schema.QueryPart1_1 AS QueryPart1_1, " .
 "       schema.QueryPart1_2b AS QueryPart1_2b, " .
 "       schema.QueryPart2 AS QueryPart2, " .
 "       schema.QueryPart3 AS QueryPart3, " .
 "       schema.QueryPart4 AS QueryPart4, " . 
 "       schema.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))
{  

$sql = 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 = '$variable6'");
}

while($row = mysqli_fetch_object($sql)) 
      {
$ID_Dataset = $row->ID_Dataset;      
$Provider = $row->Provider; 
$QueryPart1b = $row->QueryPart1b;
$QueryPart1_1 = $row->QueryPart1_1;
$QueryPart1_2b = $row->QueryPart1_2b;
$QueryPart2 = $row->QueryPart2;
$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($ID_Schema == 3 and $CatalogNoText == "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 != "True")
{
$file = $Provider.$QueryPart1b.$Digir_Resource1.$QueryPart1_1.$Digir_Source1.$QueryPart1_2b."Cata
logNumber%3E".$SourceUnitID."%3C%2Fdarwin%3ACatalogNumber".$QueryPart3.$SourceInstitutionCode.$QueryPart4.$SourceCode.$QueryPart5;
} 

else
{
$file = $Provider.$QueryPart1b.$Digir_Resource1.$QueryPart1_1.$Digir_Source1.$QueryPart1_2b.$SourceUnitID.$QueryPart3.$SourceInstitutionCode.$QueryPart4.$SourceCode.$QueryPart5; }

include ("verify.php");
}


if($formSubmitVerify2)
{

$SpecimenNumber = urlencode($_POST['formUnitIDAssoc2']);

if(empty($formProviderAssoc2))
{
echo "<a id='Red'>Please select a Specimen Database!</a>";}

else {

$sql = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dataset.ID_Dataset, " .
 "       dataset.FK_Provider, " .
 "       schemata.QueryPart1, " .
 "       schemata.QueryPart1_1, " .
 "       schemata.QueryPart1_2, " .
 "       schemata.QueryPart2, " .
 "       schemata.QueryPart3, " .
 "       schemata.QueryPart4, " . 
 "       dataset.Digir_Resource, " .
 "       dataset.Digir_Source, " .
 "       provider.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 = '$formProviderAssoc2'");

while($row = mysqli_fetch_object($sql)) 
      {
$ID_Dataset = $row->ID_Dataset;
$ID_Provider = $row->FK_Provider;
$Provider = $row->Provider; 
$QueryPart1 = $row->QueryPart1;
$QueryPart1_1 = $row->QueryPart1_1;
$QueryPart1_2 = $row->QueryPart1_2;
$QueryPart2 = $row->QueryPart2;
$QueryPart2a = $row->QueryPart2a;
$QueryPart3 = $row->QueryPart3;
$QueryPart4 = $row->QueryPart4;
$Digir_Resource = $row->Digir_Resource;
$Digir_Source = $row->Digir_Source;
$ID_Schema = $row->FK_Schema;

}

$Digir_Resource1 = urlencode($Digir_Resource);
$Digir_Source1 = urlencode($Digir_Source);


//if($ID_Dataset == '1' and $ID_Provider == '0')
/*if($ID_Dataset == '1')
{
include ("../sptool/show_cache_data.php");
}*/

//else {

include ("verify.php");

//}
}
}



   $variable1 = $_POST['formUnitID']; 
   $CatalogNoText = $_POST['CatalogNoText']; 
   $variable2 = $_POST['formSourceInstitutionID'];
   $variable3 = $_POST['formSourceID']; 
   $variable4 = $_POST['formProviderExtern'];
   $variable5 = $_POST['formTest'];
   $variable6 = $_POST['formProviderIntern'];

   
   if($variable5 != "" and !$formSubmitVerify1 and !$formSubmitSave)
   {

$mykey = key($variable5);   

if(!empty($variable4))
{   
$sql = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT dataset.ID_Dataset AS ID_Dataset, " .
 "       schema.QueryPart1b AS QueryPart1b, " .
 "       schema.QueryPart1_1 AS QueryPart1_1, " .
 "       schema.QueryPart1_2b AS QueryPart1_2b, " .
 "       schema.QueryPart2 AS QueryPart2, " .
 "       schema.QueryPart3 AS QueryPart3, " .
 "       schema.QueryPart4 AS QueryPart4, " . 
 "       schema.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))
{  

$sql = 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 = '$variable6'");
}

while($row = mysqli_fetch_object($sql)) 
      {
$ID_Dataset = $row->ID_Dataset;      
$Provider = $row->Provider; 
$QueryPart1b = $row->QueryPart1b;
$QueryPart1_1 = $row->QueryPart1_1;
$QueryPart1_2b = $row->QueryPart1_2b;
$QueryPart2 = $row->QueryPart2;
$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($ID_Schema == 3 and $CatalogNoText == "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 != "True")
{
$file = $Provider.$QueryPart1b.$Digir_Resource1.$QueryPart1_1.$Digir_Source1.$QueryPart1_2b."Cata
logNumber%3E".$SourceUnitID."%3C%2Fdarwin%3ACatalogNumber".$QueryPart3.$SourceInstitutionCode.$QueryPart4.$SourceCode.$QueryPart5;
} 

else
{
$file = $Provider.$QueryPart1b.$Digir_Resource1.$QueryPart1_1.$Digir_Source1.$QueryPart1_2b.$SourceUnitID.$QueryPart3.$SourceInstitutionCode.$QueryPart4.$SourceCode.$QueryPart5; }

include ("verify.php");
}


?>