Template:Individual infobox/marriages: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (21 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{!}}- | <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 19: | Line 18: | ||
{{!}} {{{TNGmarrplace}}} | {{!}} {{{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}}}' | |||
{{#display_external_table:template=Individual infobox/children|data=childID={{{TNGfamilyID}}}childID,childlastname={{{TNGfamilyID}}}childlastname,childfirstname={{{TNGfamilyID}}}childfirstname,childbirthdate={{{TNGfamilyID}}}childbirthdate,childdeathdate={{{TNGfamilyID}}}childdeathdate}} | |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}} | |||
<noinclude> | {{!}}- | ||
{{#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}}}}}}