Template:Infobox individual/voyages: Difference between revisions

From 'City of Adelaide' History and Genealogy Site
Jump to navigation Jump to search
(Created page with "<includeonly>{{#get_db_data:db=tng_db |from=tng_children LEFT JOIN tng_people ON tng_children.personID=tng_people.personID |where=tng_children.familyID='{{{TNGfamilyID}}}'...")
 
No edit summary
Line 1: Line 1:
<includeonly>{{#get_db_data:db=tng_db
<includeonly>{{Infobox | decat = yes | child = yes
   |from=tng_children LEFT JOIN tng_people ON tng_children.personID=tng_people.personID
| headerstyle = background: {{Roleclass colour|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}|3}}; font-size:100%;
  |where=tng_children.familyID='{{{TNGfamilyID}}}'
| header3= {{#switch:{{{VOYvoyid}}}|
  |order by=tng_people.birthdate ASC
| v1864la = [[Voyage to Adelaide in 1864]]
  |data={{{TNGfamilyID}}}childID=tng_children.personID,{{{TNGfamilyID}}}childlastname=tng_people.lastname,{{{TNGfamilyID}}}childfirstname=tng_people.firstname,{{{TNGfamilyID}}}childbirthdate=tng_people.birthdate,{{{TNGfamilyID}}}childdeathdate=tng_people.deathdate}}<!--
| v1865al = [[Voyage to London in 1865]]
| v1865la = [[Voyage to Adelaide in 1865]]
| v1866al = [[Voyage to London in 1866]]
| v1866la = [[Voyage to Adelaide in 1866]]
| v1867al = [[Voyage to London in 1867]]
| v1867la = [[Voyage to Adelaide in 1867]]
| v1868al = [[Voyage to London in 1868]]
| v1868la = [[Voyage to Adelaide in 1868]]
| v1869al = [[Voyage to London in 1869]]
| v1869la = [[Voyage to Adelaide in 1869]]
| v1870al = [[Voyage to London in 1870]]
| v1870la = [[Voyage to Adelaide in 1870]]
| v1871al = [[Voyage to London in 1871]]
| v1871la = [[Voyage to Adelaide in 1871]]
| v1872al = [[Voyage to London in 1872]]
| v1872la = [[Voyage to Adelaide in 1872]]
| v1873al = [[Voyage to London in 1873]]
| v1873la = [[Voyage to Adelaide in 1873]]
| v1874al = [[Voyage to London in 1874]]
| v1874la = [[Voyage to Adelaide in 1874]]
| v1875al = [[Voyage to London in 1875]]
| v1875la = [[Voyage to Adelaide in 1875]]
| v1876al = [[Voyage to London in 1876]]
| v1876la = [[Voyage to Adelaide in 1876]]
| v1877al = [[Voyage to London in 1877]]
| v1877la = [[Voyage to Adelaide in 1877]]
| v1878al = [[Voyage to London in 1878]]
| v1878la = [[Voyage to Adelaide in 1878]]
| v1879al = [[Voyage to London in 1879]]
| v1879la = [[Voyage to Adelaide in 1879]]
| v1880al = [[Voyage to London in 1880]]
| v1880la = [[Voyage to Adelaide in 1880]]
| v1881al = [[Voyage to London in 1881]]
| v1881la = [[Voyage to Adelaide in 1881]]
| v1882al = [[Voyage to London in 1882]]
| v1882la = [[Voyage to Adelaide in 1882]]
| v1883al = [[Voyage to London in 1883]]
| v1883la = [[Voyage to Adelaide in 1883]]
| v1884al = [[Voyage to London in 1884]]
| v1884la = [[Voyage to Adelaide in 1884]]
| v1885al = [[Voyage to London in 1885]]
| v1885la = [[Voyage to Adelaide in 1885]]
| v1886al = [[Voyage to London in 1886]]
| v1886la = [[Voyage to Adelaide in 1886]]
| v1887al = [[Voyage to London in 1887]]
|#default =
}}
| label1    = Personal role
|  data1    = {{#switch:{{{VOYtype|}}}
| passenger = {{#switch:{{{VOYroleclass}}} |First=First Class Passenger |Second=Second Class Passenger |Steerage=Steerage Class Passenger }}
| crew      = {{{VOYoccupation|}}}
|#default   = }}
 
| label2    = Name on list
|  data2    = {{{VOYlist_firstname|}}} {{{VOYlist_lastname|}}}
 
| label3    = Age on voyage
|  data3    = {{{VOYage|}}}
 
| label4    = Occupation
|  data4    = {{#ifeq:{{{VOYtype|}}}|passenger|{{{VOYoccupation|}}}}}
 
| label5    = Passage type
| data5    = {{#ifeq:{{{VOYtype|}}}|passenger|{{{VOYpassage|}}}}}
 
| label6    = Wage
|  data6    = {{{VOYwage|}}}
 
| label7    = Last ship
|  data7    = [[{{{VOYlastship|}}}]]
 
| label8    = Joined date
|  data8    = {{{VOYjoineddate|}}}
 
| label9    = Joined place
|  data9    = {{{VOYjoinedplace|}}}
 
| label10  = Left date
|  data10  = {{{VOYleftdate|}}}


-->{{Infobox | decat = yes | child = yes
| label11  = Left place
| headerstyle = background: {{Roleclass colour|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}|3}}; font-size:100%;
|  data11  = {{{VOYleftplace|}}}
| header3= {{TNGfamily|{{{TNGfamilyID}}}}}
 
| label4    = Spouse
| label12   = Left reason
|  data4    = {{#switch:{{lc:{{#iferror:{{#external_value:TNGgender}}}}}}|
|  data12   = {{{VOYleftreason|}}}
  |male  |m = {{TNGperson|{{{TNGwife|}}}|biobd}}
  |female|f = {{TNGperson|{{{TNGhusband|}}}|biobd}}
  |#default = {{TNGperson|{{{TNGwife|}}}|biobd}}
  }}
| label5   = Married
|  data5   = {{#if:{{{TNGmarrdate|}}}{{{TNGmarrplace|}}}|{{br separated entries|1={{{TNGmarrdate|}}}|2={{#if:{{{TNGmarrplace|}}}|{{{TNGmarrplace|}}}}}}}}}


| label9  = Children:
|  data9  = {{#if:{{#iferror:{{#external_value:{{{TNGfamilyID}}}childID}}}}}|{{Infobox | decat = yes | child = yes
  | datastyle = border-bottom:1px solid #aaaaaa; text-align:left
  | data10 = {{#display_external_table:template=Infobox individual/children|data=childID={{{TNGfamilyID}}}childID,childlastname={{{TNGfamilyID}}}childlastname,childfirstname={{{TNGfamilyID}}}childfirstname,childbirthdate={{{TNGfamilyID}}}childbirthdate,childdeathdate={{{TNGfamilyID}}}childdeathdate}} }}&nbsp;</br>
  }}
}}</includeonly><noinclude>
}}</includeonly><noinclude>
[[Category:Data retrieval templates]]
[[Category:Data retrieval templates]]

Revision as of 08:58, 2 October 2014

{{#invoke:documentation|main|_content={{ {{#invoke:documentation|contentTitle}}}}}}

Retrieved from ‘http://cityofadelaide.org/mw/index.php?title=Template:Infobox_individual/voyages&oldid=18690’