"; } } if($detail != "true") { if($formSubmitUpdate and $FK_ParentID_Collection > 0) { echo ""; } } ?> or use GUID as ID'; } else { echo ""; } ?> 0) { echo ''; } //if(mysqli_num_rows($resultassociations) > 0) if($FK_ParentID_Collection > 0) { $resultparent = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptoolcollection.UnitID_Specimen, " . " sptoolcollection.CollectionCode_Specimen, " . " sptoolcollection.InstitutionCode_Specimen, " . " basisofrecordspecimen.BasisOfRecord_Specimen AS BasisOfRecord, " . " kindofunit.KindOfUnit, " . " methods.Method AS PrepType, " . " sptoolcollection.PrepDate " . " FROM sptoolcollection " . " LEFT JOIN basisofrecordspecimen ON sptoolcollection.FK_BasisOfRecord = basisofrecordspecimen.ID_BasisOfRecord_Specimen " . " LEFT JOIN kindofunit ON sptoolcollection.FK_KindOfUnit = kindofunit.ID_KindOfUnit " . " LEFT JOIN methods ON sptoolcollection.FK_PrepType = methods.ID_Method " . " WHERE ID_Collection = $FK_ParentID_Collection"); echo ''; } //if($FK_ParentID_Collection > 0) } ?> "; } ?>

Voucher Data (Main Voucher, Tissue Sample or Observation)

Parent Specimen"; $Parent = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT UnitID_Specimen FROM sptoolcollection WHERE ID_Collection = '$formParentFK'"); while($row=mysqli_fetch_object($Parent)) { echo $row->UnitID_Specimen; } echo " Relation to Parent"; $echoRelation = $MainRelation; build_select_list("formRelation", "SELECT ID_Relation, Relation FROM relation " . "ORDER BY ID_Relation", $echoRelation); echo " "; if($detail != "true") { echo ' '; } echo "
Parent Specimen"; $Parent = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT UnitID_Specimen FROM sptoolcollection WHERE ID_Collection = '$FK_ParentID_Collection'"); while($row=mysqli_fetch_object($Parent)) { echo $row->UnitID_Specimen; } echo " Relation to Parent"; $echoRelation = $RelationToParent; build_select_list("formRelation", "SELECT ID_Relation, Relation FROM relation " . "ORDER BY ID_Relation", $echoRelation); echo " "; if($detail != "true") { echo ' '; } echo "
Specimen/Sample Number '; } ?>
Institution
(place of deposit) *
'; } ?>
Collection *
'; } ?>
Basis of Record * Kind of Unit * '; } ?>
Preparation Date '; } ?> Preparation Type '; } ?>
Preparation Staff '; } ?>
Preparation Materials '; } ?> Preparation Process '; } ?>
'; while($row=mysqli_fetch_object($resultassociations)) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo '

Associated subsamples

Specimen Number/ID".build_href1('query_sptool.php?sqlType=Detail&ID_Collection='.$row->ID_Collection, $row->UnitID_Specimen)."Relation to parent".$row->Relation."
Institution (place of deposit)".$row->InstitutionCode_Specimen."Collection".$row->CollectionCode_Specimen."
Basis of Record".$row->BasisOfRecord."Kind of Unit".$row->KindOfUnit."
Preparation Date".$row->PrepDate."Preparation Type".$row->PrepType."

'; while($row=mysqli_fetch_object($resultparent)) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo '

Parent record

Specimen Number/ID".build_href1('query_sptool.php?sqlType=Detail&ID_Collection='.$row->ID_Collection, $row->UnitID_Specimen)."Relation to parent".$RelationToParent."
Institution (place of deposit)".$row->InstitutionCode_Specimen."Collection".$row->CollectionCode_Specimen."
Basis of Record".$row->BasisOfRecord."Kind of Unit".$row->KindOfUnit."
Preparation Date".$row->PrepDate."Preparation Type".$row->PrepType."

'; while($row = mysqli_fetch_object($resultVoucherRef)) { $ID_Reference = $row->ID_Reference; echo '"; echo ''; echo ''; } ?> '; } else { ?> "; } } if($detail != "true") { ?>

Voucher references

'; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin'])) {} else { echo " onclick="return confirm('Are you sure you want to delete this reference?');"> "; } echo "
Full citation format *'; echo '
Reference detail (page)'; echo ''; echo '
Add further references (related to specimen/observation)
Add voucher reference (related to specimen/observation) onclick="document.getElementById('hiddenRef').style.display = this.checked == true ? 'block':'none';" value="Ref" />
0) { echo ''; while($row = mysqli_fetch_object($resultVoucherRef)) { echo ''; } echo "

References (related to specimen/observation)

Full citation format'.build_href1($row->ReferenceUrl, $row->ReferenceText).'
Reference detail (page)'.$row->ReferenceDetail.'

style="display:none;" width='98%' />

References (related to specimen/observation) No.1

Full citation format '; ?>
" target="blank">
Reference detail (page)'; ?>

References (related to specimen/observation) No.2

Full citation format '; ?>
" target="blank">
Reference detail (page)'; ?>

References (related to specimen/observation) No.3

Full citation format '; ?>
" target="blank">
Reference detail (page)'; ?>
Add (External) Associations (related to specimen/observation)/>
> "; echo ""; include ("../input/doQuery.php"); echo "

TODO: Save/Update: Associated Record

Relation to Main Record"; $echoRelationAssoc = $RelationAssoc; build_select_list("formRelationAssoc", "SELECT ID_Relation, Relation FROM relation " . "ORDER BY ID_Relation", $echoRelationAssoc); echo " "; if($detail != "true") { echo ' '; } echo "Notes

'; while($row = mysqli_fetch_object($resultMMSpecimen)) { $ID_MSpecimen = $row->ID_Multimedia; echo '"; echo ''; } ?> '; } else { ?> "; } if($detail == "true" and mysqli_num_rows($resultAssocUnit)) { echo '

Multimedia (related to specimen/observation)

'; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin'])) {} else { echo " onclick="return confirm('Are you sure you want to delete this multimedia item?');"> "; } echo "
Path and File Name *'; echo ''; echo '
Context'; echo ''; echo ' Comment'; echo ''; echo '
Creator'; echo ''; echo ' Created (datetime)'; echo 'File_Created_When == "") { echo 'value="YYYY-MM-DD hh:mm:ss">'; } else { echo 'value="'.$row->File_Created_When.'">'; } echo '
Type'; echo ''; echo 'License'; echo '
Add further Multimedia items (related to specimen/observation)
Add Multimedia items (related to specimen/observation) onclick="document.getElementById('hiddenMultSp').style.display = this.checked == true ? 'block':'none';" value="MultSp" />
'; echo ''; while($row = mysqli_fetch_object($resultAssocUnit)) { echo ''; } } ?> ID_TaxonIdentified; echo '"; }} ?>

Associated Unit

Voucher ID'.$row->UnitID.'Institution'.$row->InstitutionCode.'
Collection'.$row->CollectionCode.'Relation to Main Unit'.$row->RelationToMainUnit.'
Basis of Record'.$row->RecordBasis.'Kind Of Unit'.$row->KindOfUnit.'
Specimen database'.$row->Display.'
0) { echo ''; while($row = mysqli_fetch_object($resultMMSpecimen)) { echo ''; } echo "

Multimedia (related to specimen/observation)

Item'; if($row->File_Type == 'Image/Scan') { list($width, $height, $type, $attr) = getimagesize($row->File_Path); if($width > 120 and $height > 120) { $widthMM = '120px'; } if($width > 120 and $height <= 120) { $widthMM = '120px'; } if($width <= 120 and $height > 120) { $heightMM = '120px'; } echo ""; } else { echo "".$row->File_Path.""; } echo 'Type'.$row->File_Type.'
Context'.$row->File_Context.' Comment'.$row->File_Comment.'
Creator'.$row->File_Created_Who.' Created (datetime)'.$row->File_Created_When.'
License'.$row->File_License.'

"; } } if($detail != "true") { ?> style="display:none;" width='98%' >

Multimedia (related to specimen/observation) No.1

Path pre-defineduser settings."; } ?>
Use pre-defined path />
(Path and) File Name *
Context Comment
Creator "> Created (date or datetime) ">
or use EXIF DateTimeOriginal />
Type License (e.g. CC-BY-NC) ">

Multimedia (related to specimen/observation) No.2

Path pre-defineduser settings."; } ?>
Use pre-defined path />
(Path and) File Name *
Context Comment
Creator "> Created (date or datetime) ">
or use EXIF DateTimeOriginal />
Type License (e.g. CC-BY-NC) ">

Multimedia (related to specimen/observation) No.3

Path pre-defineduser settings."; } ?>
Use pre-defined path />
(Path and) File Name *
Context Comment
Creator "> Created (date or datetime) ">
or use EXIF DateTimeOriginal />
Type License (e.g. CC-BY-NC) ">
'; } else { echo ''; } if($formSubmitUpdate and !$formSubmitTemplate) { echo '"; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin']) ) {} else { if($ID_TaxonIdentified != "") { echo " onclick="return confirm('Are you sure you want to delete the preferred identification?');"> "; }} echo ""; } echo ""; if($detail == "true") { while($row = mysqli_fetch_object($result3)) { echo ''; } } else { ?> HigherTaxon; } while($row = mysqli_fetch_object($result3b)) { $Phylum = $row->HigherTaxon; } while($row = mysqli_fetch_object($result3c)) { $Class = $row->HigherTaxon; } while($row = mysqli_fetch_object($result3d)) { $Order = $row->HigherTaxon; } while($row = mysqli_fetch_object($result3e)) { $Family = $row->HigherTaxon; } while($row = mysqli_fetch_object($result3f)) { $Subfamily = $row->HigherTaxon; } } ?>

'; } else { echo '

'; } if($detail == "true") { echo "Preferred Identification: ".$NameAuthorYear; } else { echo "Preferred Identification"; } ?>

'.$row->TaxonRank.''.$row->HigherTaxon.'
Kingdom "/>
Phylum "/>
Class "/>
Order "/>
Family "/>
Subfamily "/>

Identification Qualifier '; }?> Qualifier belongs to '; } ?>

Genus ';if(!$formSubmitUpdate or $_GET['SpecimenTemplate'] != "") { echo ''; } echo '
'; if($formSubmitUpdate and !$formSubmitTemplate) {echo '';} }?>
Subgenus
'; }?>
Specific Epithet
'; }?>
Rank '; } ?>
Infraspecific Epithet
'; }?>
Name Addendum '; }?>
Breed/Cultivar '; }?>
Author(s) in parenthesis
'; }?>
Year in parenthesis '; }?>
Author(s)
'; }?>
Year '; }?>
Identifier '; }?> Identification Date '; }?>
Kind of Identification '; } ?> Identification Notes '; }?>
Preferred Identification /> Add identification onclick="document.getElementById('hidden').style.display = this.checked == true ? 'block':'none';" value="Further"/>
ID_TaxonIdentified; echo ""; $result3a = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon AS HigherTaxon2, " . " sptoolhighertaxon.TaxonRank AS TaxonRank2" . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptooltaxa.PreferredFlag != '1' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa'"); while($roww = mysqli_fetch_object($result3a)) { echo ''; } echo ""; echo "

Further Identification: ".$row->NameAuthorYear."

'.$roww->TaxonRank2.''.$roww->HigherTaxon2.'

Genus".$row->Genus."Subgenus".$row->Subgenus."
Specific Epithet".$row->SpecificEpithet."
Rank".$row->Rank."Infraspecific Epithet".$row->InfraspecificEpithet."
Author(s) in parenthesis".$row->AuthorParenth."Year in parenthesis".$row->YearParenth."
Author(s)".$row->Author."Year".$row->Year."
Identifier".$row->Identifier."Identification Date".$row->IdentificationDate."
Kind of Identification".$row->KindOfIdentification."IdentificationNotes".$row->IdentificationNotes."
"; } echo "
"; } if($formSubmitUpdate or $sqlType != "Detail") { ?> style="display:none;" class="greenline">

Identification No 2

Kingdom "/>
Phylum "/>
Class "/>
Order "/>
Family "/>
Subfamily "/>

Identification Qualifier '; }?> Qualifier belongs to '; } ?>

Genus "/> '; } ?>
Subgenus "/>
Specific Epithet "/>
Rank '; ?>
Infraspecific Epithet"/>
Name Addendum '; }?>
Breed/Cultivar '; }?>
Author(s) in parenthesis"/>
Year in parenthesis"/>
Author(s)"/>
Year"/>
Identifier"/> Identification Date"/>
Kind of Identification '; ?> Identification Notes"/>
Preferred Identification/> Add identification onclick="document.getElementById('hidden1').style.display = this.checked == true ? 'block':'none';" value="Further"/>
style="display:none;" class="greenline">

Identification No 3

Kingdom "/>
Phylum "/>
Class "/>
Order "/>
Family "/>
Subfamily "/>

Genus "/> '; } ?>
Subgenus "/>
Specific Epithet"/>
Rank '; ?> Infraspecific Epithet"/>
Author(s) in parenthesis"/>
Year in parenthesis"/>
Author(s)"/>
Year"/>
Identifier"/> Identification Date"/>
Kind of Identification '; ?> Identification Notes"/>
Preferred Identification/> Add identification onclick="document.getElementById('hidden2').style.display = this.checked == true ? 'block':'none';" value="Further"/>
style="display:none;" class="greenline">

Identification No 4

Kingdom "/>
Phylum "/>
Class "/>
Order "/>
Family "/>
Subfamily "/>

Genus "/> '; } ?>
Subgenus "/>
Specific Epithet"/>
Rank '; ?> Infraspecific Epithet"/>
Author(s) in parenthesis"/>
Year in parenthesis"/>
Author(s)"/>
Year"/>
Identifier"/> Identification Date"/>
Kind of Identification '; ?> Identification Notes"/>
Preferred Identification/>
'; echo ""; $result3g = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptooltaxa.PreferredFlag = '0' " . " AND sptoolhighertaxon.TaxonRank = 'regnum' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa'"); $result3h = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptooltaxa.PreferredFlag = '0' " . " AND sptoolhighertaxon.TaxonRank = 'phylum' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa'"); $result3i = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptooltaxa.PreferredFlag = '0' " . " AND sptoolhighertaxon.TaxonRank = 'classis' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa'"); $result3j = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptooltaxa.PreferredFlag = '0' " . " AND sptoolhighertaxon.TaxonRank = 'ordo' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa'"); $result3k = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptooltaxa.PreferredFlag = '0' " . " AND sptoolhighertaxon.TaxonRank = 'familia' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa'"); $result3l = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptooltaxa.PreferredFlag = '0' " . " AND sptoolhighertaxon.TaxonRank = 'subfamilia' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa'"); echo ''; echo ""; echo ''; echo ''; echo ''; echo ""; echo "

Further Identification

"; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin'])) {} else { echo " onclick="return confirm('Are you sure you want to delete this identification?');"> "; } echo "
Kingdom'; echo '
Phylum
Class
Order
Family
Subfamily

Genus
Subgenus
Specific Epithet
Rank"; $ViewRank = $row->Rank; echo ''; echo "Infraspecific Epithet
Author(s) in parenthesisYear in parenthesis
Author(s)Year
IdentifierIdentification Date
Kind of Identification"; $ViewKindOfIdentification = $row->KindOfIdentification; echo ''; echo "IdentificationNotes
Preferred Identification
"; echo "
'; ?>

Gathering Details

Expedition/Title label '; } ?> Collection Method '; } ?>
Collector(s) '; } ?> Collector's No '; } ?>
Collection date from '; } ?> Collection date to '; } ?>
Collection Notes '; if($formSubmitUpdate) { echo $CollectionNotes; } if($EntryCheck == "true") { echo $formCollectionNotes; } if(!$formSubmitSave and !$formSubmitCopy) { echo $_POST['formCollectionNotes']; } echo ''; } ?> '; } echo '
'; } ?>

Geography

Biogeographic Region Sea/Ocean
Country State/Province/Greater Area '; } ?>
Locality '; } ?> Locality ID/Station '; } ?>
Slope Prevalent Aspect
Altitude Accuracy Statement '; } ?> Altitude from '; } ?> '; } ?> '; } ?>
Altitude Method '; } ?> Raw data Altitude '; } ?>
Depth Accuracy Statement '; } ?> Depth from '; } ?> '; } ?> '; } ?>
Depth Method '; } ?> Raw data Depth '; } ?>

Geodetic Datum '; } ?> Geocode Method
Coordinates Accuracy Statement '; } ?> Error distance in m '; } ?>
Latitude decimal from '; } ?>Longitude decimal from '; } ?>
Latitude decimal to '; } ?>Longitude decimal to '; } ?>
Raw data Latitude '; } ?>Raw data Longitude '; } ?>
'; ?>
'; while($row = mysqli_fetch_object($resultMMSite)) { $ID_MSite = $row->ID_Multimedia; echo '"; echo ''; } ?> '; } else { ?>

Multimedia (related to gathering site)

'; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin'])) {} else { echo " onclick="return confirm('Are you sure you want to delete this multimedia item?');"> "; } echo "
Path and File Name *'; echo ''; echo '
Context'; echo ''; echo 'Comment'; echo '
Creator'; echo ''; echo ' Created (datetime)'; echo ''; echo '
Type'; echo ''; echo 'License'; echo ''; echo '
Add further Multimedia items (related to gathering site)
Add Multimedia items (related to gathering site)
0) { echo ''; while($row = mysqli_fetch_object($resultMMSite)) { echo ''; } echo "

Multimedia (related to gathering site)

Item'; if($row->File_Type == 'Image/Scan') { list($width, $height, $type, $attr) = getimagesize($row->File_Path); if($width > 120 and $height > 120) { $widthMMSite = '120px'; } if($width > 120 and $height <= 120) { $widthMMSite = '120px'; } if($width <= 120 and $height > 120) { $heightMMSite = '120px'; } echo ""; } else { echo "".$row->File_Path.""; } echo 'Type'.$row->File_Type.'
Context'.$row->File_Context.' Comment'.$row->File_Comment.'
Creator'.$row->File_Created_Who.' Created (datetime)'.$row->File_Created_When.'
License'.$row->File_License.'

"; } } if($detail != "true") { ?>
0) { echo ""; } } else { ?> '; } ?> '; while($row = mysqli_fetch_object($result3Host)) { echo ''; } echo ''; } /******************************if($formSubmitUpdate)********************/ if($formSubmitUpdate and !$formSubmitTemplate) { $num_rows = mysqli_num_rows($result2b); } if($formSubmitUpdate and $result2b) { while($row = mysqli_fetch_object($result2b)) { $ID_Taxa_Host = $row->ID_TaxonIdentified; echo '"; }} /******************************END if($formSubmitUpdate)********************/ if($detail != "true") { ?> 0) { echo ""; } } else { ?> '; } ?> 0) { echo ""; } } else { if($formSubmitUpdate) { $sqlGenAcc = "SELECT * FROM sptoolgeneticaccessions WHERE FK_Collection = '$ID_Collection'"; $resultGenAcc = mysqli_query($GLOBALS["___mysqli_ston"], $sqlGenAcc); if($resultGenAcc) { echo ''; } //if($formSubmitUpdate) ?>

Ecological Data

Soil texture Soil pH
Habitat code Land use code
Habitat/Ecological aspects '; if($formSubmitUpdate) { echo $Habitat; } if($EntryCheck == "true") { echo $formHabitat; } if(!$formSubmitSave and !$formSubmitCopy) { echo $_POST['formHabitat']; } echo ''; } ?>
"; while($row = mysqli_fetch_object($result4)) { echo ""; } echo "
ValueUnitParameterMethod
".$row->Value."".$row->Unit."".$row->Parameter."".$row->Method."
'; while($row = mysqli_fetch_object($resultEcology)){ $ID_Eco = $row->ID_Measurement; echo '"; } } echo '
Value Unit Parameter Method '; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin'])) {} else { echo " onclick="return confirm('Are you sure you want to delete this eco parameter?');"> "; } echo "
Add ecological parameters onclick="document.getElementById('hiddenEcology').style.display = this.checked == true ? 'block':'none';" value="Ecology"/>
style="display:none;" class="greenline">
Value 1 "/> Unit 1 "/> Parameter 1 "/> Method 1 "/>
Value 2 "/> Unit 2 "/> Parameter 2 "/> Method 2 "/>
Value 3 "/> Unit 3 "/> Parameter 3 "/> Method 3 "/>
Value 4 "/> Unit 4 "/> Parameter 4 "/> Method 4 "/>
Value 5 "/> Unit 5 "/> Parameter 5 "/> Method 5 "/>
Value 6 "/> Unit 6 "/> Parameter 6 "/> Method 6 "/>
Value 7 "/> Unit 7 "/> Parameter 7 "/> Method 7 "/>
Value 8 "/> Unit 8 "/> Parameter 8 "/> Method 8 "/>
Value 9 "/> Unit 9 "/> Parameter 9 "/> Method 9 "/>
Value 10 "/> Unit 10 "/> Parameter 10 "/> Method 10 "/>

Host species '.$NameAuthorYearHost.'

'.$row->TaxonRank.''.$row->HigherTaxon.'

Genus'.$GenusHost.' Subgenus'.$SubgenusHost.'
Specific Epithet'.$SpecificEpithetHost.'
Rank'.$RankHost.' Infraspecific Epithet'.$InfraspecificEpithetHost.'
Author(s) in parenthesis'.$AuthorParenthHost.' Year in parenthesis'.$YearParenthHost.'
Author(s)'.$AuthorHost.' Year'.$YearHost.'
Identifier'.$IdentifierHost.' Identification Date'.$IdentificationDateHost.'
Kind of Identification'.$KindOfIdentificationHost.' Identification Notes'.$IdentificationNotesHost.'
'; echo ""; $result3g = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptoolhighertaxon.TaxonRank = 'regnum' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa_Host'"); $result3h = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptoolhighertaxon.TaxonRank = 'phylum' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa_Host'"); $result3i = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptoolhighertaxon.TaxonRank = 'classis' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa_Host'"); $result3j = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptoolhighertaxon.TaxonRank = 'ordo' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa_Host'"); $result3k = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptoolhighertaxon.TaxonRank = 'familia' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa_Host'"); $result3l = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " . " sptooltaxa.ID_TaxonIdentified, " . " sptoolhighertaxon.HigherTaxon, " . " sptoolhighertaxon.TaxonRank " . " FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " . " WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " . " AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " . " AND sptoolhighertaxon.TaxonRank = 'subfamilia' " . " AND sptoolhighertaxon.FK_TaxonIdentified = '$ID_Taxa_Host'"); echo ''; echo ""; echo ''; echo ''; echo ''; echo "

Host species

"; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin'])) {} else { echo " onclick="return confirm('Are you sure you want to delete this host identification?');"> "; } echo "
Kingdom'; echo '
Phylum
Class
Order
Family
Subfamily

Genus
Subgenus
Specific Epithet
Rank"; $ViewRank = $row->Rank; echo ''; echo "Infraspecific Epithet
Author(s) in parenthesisYear in parenthesis
Author(s)Year
IdentifierIdentification Date
Kind of Identification"; $ViewKindOfIdentification = $row->KindOfIdentification; echo ''; echo "IdentificationNotes
"; echo "
Add host species onclick="document.getElementById('hiddenHost').style.display = this.checked == true ? 'block':'none';" value="Host"/>
style="display:none;" class="greenline">

Host species

Kingdom "/>
Phylum "/>
Class "/>
Order "/>
Family "/>
Subfamily "/>

Genus "/> '; } ?>
Subgenus "/>
Specific Epithet ">
Rank '; ?> Infraspecific Epithet">
Author(s) in parenthesis">
Year in parenthesis">
Author(s)">
Year">
Identifier"> Identification Date">
Kind of Identification '; ?> Identification Notes">

Morphological Data

"; while($row = mysqli_fetch_object($result5)) { echo ""; } echo "
ValueUnitParameterMethod
".$row->Value."".$row->Unit."".$row->Parameter."".$row->Method."

Morphological Data

'; while($row = mysqli_fetch_object($resultMorphology)){ $ID_Morpho = $row->ID_Measurement; echo '"; } } echo '
Value Unit Parameter Method '; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin'])) {} else { echo " onclick="return confirm('Are you sure you want to delete this morpho parameter?');"> "; } echo "
Add morphological parameters onclick="document.getElementById('hiddenMorphology').style.display = this.checked == true ? 'block':'none';" value="Morphology"/>
style="display:none;" class="greenline">
Value 1 "/> Unit 1 "/> Parameter 1 "/> Method 1 "/>
Value 2 "/> Unit 2 "/> Parameter 2 "/> Method 2 "/>
Value 3 "/> Unit 3 "/> Parameter 3 "/> Method 3 "/>
Value 4 "/> Unit 4 "/> Parameter 4 "/> Method 4 "/>
Value 5 "/> Unit 5 "/> Parameter 5 "/> Method 5 "/>
Value 6 "/> Unit 6 "/> Parameter 6 "/> Method 6 "/>
Value 7 "/> Unit 7 "/> Parameter 7 "/> Method 7 "/>
Value 8 "/> Unit 8 "/> Parameter 8 "/> Method 8 "/>
Value 9 "/> Unit 9 "/> Parameter 9 "/> Method 9 "/>
Value 10 "/> Unit 10 "/> Parameter 10 "/> Method 10 "/>

GenBank/EMBL/DDBJ or BOLD entries

"; while($row = mysqli_fetch_object($resultGenAcc)) { echo ""; } echo "
Genetic LocusAccession NumberSample IDBOLD
".$row->GeneticLocus.""; if($row->BOLD != "") { echo build_href1($BOLD.$row->GenBankNumber, $row->GenBankNumber); } else { echo build_href1($INSDC.$row->GenBankNumber, $row->GenBankNumber); } echo "".$row->SampleID.""; if($row->BOLD != "") { echo "yes"; } echo "

GenBank/EMBL/DDBJ or BOLD entries

'; while($row = mysqli_fetch_object($resultGenAcc)){ $ID_GeneticAccession = $row->ID_GeneticAccession; echo '"; } } echo '
Genetic Locus '; build_select_listShort("formGeneticLocus[]", "SELECT ID_GeneticLocus, GeneticLocus FROM geneticlocus " . "ORDER BY GeneticLocus", $row->FK_GeneticLocus); echo '   Accession Number Sample ID BOLD BOLD != "") { echo " checked"; } echo '> '; if ((isset($_SESSION['guest']) || $_SESSION['guest']) || ((isset($_SESSION['project']) || $_SESSION['project']) && $Created_Who != $log) || !$_SESSION['loggedin'] || !isset($_SESSION['loggedin'])) {} else { echo " onclick="return confirm('Are you sure you want to delete this genetic accession number?');"> "; } echo "
Add GenBank/EMBL/DDBJ or BOLD entries onclick="document.getElementById('hiddenGenBankA').style.display = this.checked == true ? 'block':'none';" value="GenBank"/> Use this for external accession entries only. Accession numbers related to your DNA samples should be entered in the DNA part only. See Wiki for further info. Define principal url to preferred portal via general settings. Default value is url of GenBank.
style="display:none;" width="100%">
Genetic Locus    " target="_blank"> Accession No/
BOLD ID
"> Sample ID "> BOLD >
Genetic Locus    " target="_blank"> Accession No/
BOLD ID
"> Sample ID "> BOLD >
Genetic Locus    " target="_blank"> Accession No/
BOLD ID
"> Sample ID "> BOLD >
Genetic Locus    " target="_blank"> Accession No/
BOLD ID
"> Sample ID "> BOLD >
Genetic Locus    " target="_blank"> Accession No/
BOLD ID
"> Sample ID "> BOLD >
Add paleontological data onclick="document.getElementById('hiddenPaleontology').style.display = this.checked == true ? 'block':'none';" value="Paleontology"/>
style="display:none;" width="100%">

Paleontology

Dating Qualifier'; } ?>Series
Dating Qualifier'; } ?>Stage
Fossil Zone Name'; } ?>Formation'; } ?>
Section Details'; if($formSubmitUpdate) { echo $SectionDetails; } if($EntryCheck == "true" and !$formSubmitCopy) { echo $formSectionDetails; } if(!$formSubmitSave and !$formSubmitCopy) { echo $_POST['formSectionDetails']; } echo ''; } ?>
Specimen Details'; if($formSubmitUpdate) { echo $SpecimenDetails; } if($EntryCheck == "true" and !$formSubmitCopy) { echo $formSpecimenDetails; } if(!$formSubmitSave and !$formSubmitCopy) { echo $_POST['formSpecimenDetails']; } echo ''; } ?>
'; } ?> '; } ?> '; } if($formSubmitUpdate and !$formSubmitTemplate) { echo ''; } ?>

Other Data

Type Type designation '; } ?>
Life Stage '; } ?> Life Form '; } ?>
Sex

Received From '; }?>
Accession Number '; } ?> Primary Accession Name '; }?>
Preservation (repeatable) to doMaterial Consumed to do
Permits (repeatable)to do'; /*if($detail == "true") { echo $Permission; } else { echo 'Yes No Unknown
Not required '; } */ ?>
Escape Coordinates No to do'; //define escape level in general settings'; } ?>
Blocked for Loan Until "> Blocked for Loaning '; } ?>
Loan Conditions '; if($formSubmitUpdate) { echo $LoanConditions; } if($EntryCheck == "true" and !$formSubmitCopy) { echo $formLoanConditions; } if(!$formSubmitSave and !$formSubmitCopy) { echo $_POST['formLoanConditions']; } echo ''; } ?> Blocked for Publishing '; } ?>
General Remarks '; if($formSubmitUpdate) { echo $Notes; } if($EntryCheck == "true" and !$formSubmitCopy) { echo $formNotes; } if(!$formSubmitSave and !$formSubmitCopy) { echo $_POST['formNotes']; } echo ''; } ?> Internal Remarks '; if($formSubmitUpdate) { echo $NotesInternal; } if($EntryCheck == "true" and !$formSubmitCopy) { echo $formNotesInternal; } if(!$formSubmitSave and !$formSubmitCopy) { echo $_POST['formNotesinternal']; } echo ''; } ?>

Dataset

Created by "; echo 'GUID'.$GUID.'
Updated by'.$Updated_Who.' ('.$Updated_When.')