"; } } 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)

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-defined	user 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-defined	user 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-defined	user 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 parenthesis		Year in parenthesis
Author(s)		Year
Identifier		Identification 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 "

Value	Unit	Parameter	Method
".$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

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 parenthesis		Year in parenthesis
Author(s)		Year
Identifier		Identification 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 "

Value	Unit	Parameter	Method
".$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

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 Locus	Accession Number	Sample ID	BOLD
".$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 '>

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 do	Material 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.')

Voucher Data (Main Voucher, Tissue Sample or Observation)

Associated subsamples

Parent record

Voucher references

References (related to specimen/observation)

References (related to specimen/observation) No.1

References (related to specimen/observation) No.2

References (related to specimen/observation) No.3

TODO: Save/Update: Associated Record

Multimedia (related to specimen/observation)

Associated Unit

Multimedia (related to specimen/observation)

Multimedia (related to specimen/observation) No.1

Multimedia (related to specimen/observation) No.2

Multimedia (related to specimen/observation) No.3

'; } else { echo '

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

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

Identification No 2

Identification No 3

Identification No 4

Further Identification

Gathering Details

Geography

Multimedia (related to gathering site)

Multimedia (related to gathering site)

Multimedia (related to gathering site) No.1

Multimedia (related to gathering site) No.2

Multimedia (related to gathering site) No.3

Ecological Data

Host species '.$NameAuthorYearHost.'

Host species

Host species

Morphological Data

Morphological Data

GenBank/EMBL/DDBJ or BOLD entries

GenBank/EMBL/DDBJ or BOLD entries

Paleontology

Other Data

Dataset