Template:Infobox individual/marriages: Difference between revisions

From 'City of Adelaide' History and Genealogy Site
Jump to navigation Jump to search
(Undo revision 18619 by Admin (talk))
No edit summary
Line 1: Line 1:
<includeonly>{{Infobox | subbox = yes
<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}}}'
  |order by=tng_people.birthdate ASC
  |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}}
{{Infobox | subbox = yes
| titlestyle = background: {{Roleclass colour|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}|3}}; font-size:100%;
| titlestyle = background: {{Roleclass colour|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}|3}}; font-size:100%;
| title      = {{TNGfamily|{{{TNGfamilyID}}}}}
| title      = {{TNGfamily|{{{TNGfamilyID}}}}}
Line 10: Line 15:
| label5  = Married
| label5  = Married
|  data5  = {{#if:{{{TNGmarrdate|}}}{{{TNGmarrplace|}}}|{{br separated entries|1={{{TNGmarrdate|}}}|2={{#if:{{{TNGmarrplace|}}}|<span class="birthplace">{{{TNGmarrplace|}}}</span>}}}}}}
|  data5  = {{#if:{{{TNGmarrdate|}}}{{{TNGmarrplace|}}}|{{br separated entries|1={{{TNGmarrdate|}}}|2={{#if:{{{TNGmarrplace|}}}|<span class="birthplace">{{{TNGmarrplace|}}}</span>}}}}}}
}}
 
<!--
| header110 = {{#if:{{#iferror:{{#external_value:{{{TNGfamilyID}}}childID}}}}|{{Infobox | decat = yes | child = yes | title = Children }}
|    data11 = {{#if:{{#iferror:{{#external_value:{{{TNGfamilyID}}}childID}}}}|{{#display_external_table:template=Infobox individual/children|data=childID={{{TNGfamilyID}}}childID,childlastname={{{TNGfamilyID}}}childlastname,childfirstname={{{TNGfamilyID}}}childfirstname,childbirthdate={{{TNGfamilyID}}}childbirthdate,childdeathdate={{{TNGfamilyID}}}childdeathdate}} }}
 
}}<!--
{{ Count | base=1 }}
{{ Count | base=1 }}
{{!}}-
 
{{!}} class="fn" colspan="2" {{Individual infobox/style|sub_sub_header_bar|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}}} {{!}} {{TNGfamily|{{{TNGfamilyID}}}}}
--></includeonly><noinclude>
{{!}}-
! style="padding-right: 1em;" {{!}} Spouse
{{!}} {{!}}-
{{#if:{{{TNGmarrdate|}}}|
! style="padding-right: 1em;" {{!}} Married
{{!}} {{{TNGmarrdate}}}
}}
{{!}}-
{{#if:{{{TNGmarrplace|}}}|
! style="padding-right: 1em;" {{!}} Married place
{{!}} {{{TNGmarrplace}}}
}}
{{#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}}}'
  |order by=tng_people.birthdate ASC
  |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}}
{{!}}-
{{#if:{{#iferror:{{#external_value:{{{TNGfamilyID}}}childID}}}}|
! style="padding-right: 1em; border-top: {{Individual infobox/style|section_border}}" {{!}} Children
{{!}}style="padding-right: 1em; border-top: {{Individual infobox/style|section_border}}" {{!}} {{#display_external_table:template=Individual infobox/children|data=childID={{{TNGfamilyID}}}childID,childlastname={{{TNGfamilyID}}}childlastname,childfirstname={{{TNGfamilyID}}}childfirstname,childbirthdate={{{TNGfamilyID}}}childbirthdate,childdeathdate={{{TNGfamilyID}}}childdeathdate}} }}-->
</includeonly><noinclude>
[[Category:Data retrieval templates]]
[[Category:Data retrieval templates]]
[[Category:People infobox templates| ]]
[[Category:People infobox templates| ]]
{{documentation}}
{{documentation}}
</noinclude>
</noinclude>

Revision as of 01:08, 2 October 2014

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

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