Template:Individual infobox/marriages: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (28 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:{{{ | {{!}} 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 | ||
{{!}} {{#switch:{{lc:{{{ | {{!}} {{#switch:{{lc:{{#iferror:{{#external_value:TNGgender}}}}}}| | ||
|male |m = {{{TNGwife| | |male |m = {{TNGperson|{{{TNGwife|}}}|biobd}} | ||
|female|f = {{{TNGhusband| | |female|f = {{TNGperson|{{{TNGhusband|}}}|biobd}} | ||
|#default = | |#default = {{TNGperson|{{{TNGwife|}}}|biobd}} | ||
}} | }} | ||
{{!}}- | {{!}}- | ||
| 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 | |from=tng_children LEFT JOIN tng_people ON tng_children.personID=tng_people.personID | ||
|where=tng_children.familyID='{{{TNGfamilyID}}}' | |where=tng_children.familyID='{{{TNGfamilyID}}}' | ||
|order by=tng_people.birthdate ASC | |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}} | |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}}}}| | ||
<noinclude> | ! 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}}}}}}