Template:Individual infobox/marriages: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (15 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly>{{!}}- | <includeonly>{{!}}- | ||
{{!}} class="fn" colspan="2" {{Individual infobox/style|sub_sub_header_bar|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}}} {{!}} {{TNGfamily|{{{TNGfamilyID}}}}} | {{!}} class="fn" colspan="2" {{Individual infobox/style|sub_sub_header_bar|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}}} {{!}} {{TNGfamily|{{{TNGfamilyID}}}}} | ||
{{!}}- | {{!}}- | ||
! style="padding-right: 1em;" {{!}} Spouse | ! style="padding-right: 1em;" {{!}} Spouse | ||
| Line 14: | Line 13: | ||
{{!}} {{{TNGmarrdate}}} | {{!}} {{{TNGmarrdate}}} | ||
}} | }} | ||
{{!}}- | {{!}}- | ||
{{#if:{{{TNGmarrplace|}}}| | {{#if:{{{TNGmarrplace|}}}| | ||
! style="padding-right: 1em;" {{!}} Married place | ! style="padding-right: 1em;" {{!}} Married place | ||
{{!}} {{{TNGmarrplace}}} | {{!}} {{{TNGmarrplace}}} | ||
}} | }} | ||
{{ | {{#get_db_data:db=tng_db | ||
|from=tng_children LEFT JOIN tng_people ON tng_children.personID=tng_people.personID | |||
{{{{{{TNGfamilyID}}} | |where=tng_children.familyID='{{{TNGfamilyID}}}' | ||
{{#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> | |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]] | ||
{{documentation}} | {{documentation}} | ||
</noinclude> | </noinclude> | ||
Latest revision as of 11:21, 1 October 2014
{{#invoke:documentation|main|_content={{ {{#invoke:documentation|contentTitle}}}}}}