Бард-Вики

Дни рождения: различия между версиями

Статья Обсуждение
мНет описания правки
мНет описания правки
 
(не показаны 34 промежуточные версии 2 участников)
Строка 1: Строка 1:
<small>__NOCACHE__{{#vardefine:dbafter|{{#cargo_query:
<small>__NOCACHE__<!--{{#vardefine:dbafter|{{#cargo_query:
     tables=Persona
     tables=Persona
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +6 week}}'
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +6 week}}'
Строка 14: Строка 14:
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}}}
}}}}-->{{#vardefine:dbafter|{{#cargo_query:
== Дни рождения ==
    tables=Persona
<div style="line-height: 1.1;">
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +6 week}}')
{{#cargo_query:
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
    |default=
}}}}{{#vardefine:dbafter1|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '12-31')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
    |default=
}}}}{{#vardefine:dbafter2|{{#cargo_query:
    tables=Persona
    |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '01-01' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +6 week -1 year}}'
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
}}}}{{#vardefine:ddafter|{{#cargo_query:
    tables=Persona
    |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | +6 week}}'
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=
}}}}{{#vardefine:ddafter1|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '12-31')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=
}}}}{{#vardefine:ddafter2|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '01-01' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | +6 week -1 year}}')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
}}}}{{#vardefine:dbbefore|{{#cargo_query:
     tables=Persona
     tables=Persona
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d | -6 week}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | -1 day}}'
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d | -6 week}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | -1 day}}'
Строка 24: Строка 67:
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}
    |default=   
}}}}{{#vardefine:dbbefore1|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d | -6 week +1 year}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '12-31')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
    |default=   
}}}}{{#vardefine:dbbefore2|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | -1 day}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '01-01')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
    |default=   
}}}}{{#vardefine:ddbefore|{{#cargo_query:
    tables=Persona
    |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d | -6 week}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | -1 day}}'
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=   
}}}}{{#vardefine:ddbefore1|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d | -6 week +1 year}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '12-31')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=   
}}}}{{#vardefine:ddbefore2|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '01-01' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | -1 day}}')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=   
}}}}
== Дни рождения ==
<div style="line-height: 1.1;">
{{#if: {{#var:dbbefore}}|{{#var:dbbefore}}|{{#var:dbbefore1}}{{#var:dbbefore2}}}}<!--
{{#var:dbbefore1}}{{#var:dbbefore2}}-->
</div>
</div>
<!--'''{{#time: d.m.Y}}'''-->
<!--'''{{#time: d.m.Y}}'''-->
Строка 30: Строка 118:


<div style="line-height: 1.1;">
<div style="line-height: 1.1;">
{{#if: {{#var:dbafter}}|{{#var:dbafter}}|{{#var:dbafter2}}}}
{{#if: {{#var:dbafter}}|{{#var:dbafter}}|{{#var:dbafter1}}{{#var:dbafter2}}}}
 
</div>
</div>


== Дни памяти ==
== Дни памяти ==
<div style="line-height: 1.1;">
<div style="line-height: 1.1;">
{{#cargo_query:
{{#if: {{#var:ddbefore}}|{{#var:ddbefore}}|{{#var:ddbefore1}}{{#var:ddbefore2}}}}
    tables=Persona
    |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d | -6 week}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | -1 day}}'
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
}}
</div>
</div>


Строка 48: Строка 130:


<div style="line-height: 1.1;">
<div style="line-height: 1.1;">
{{#cargo_query:
{{#if: {{#var:ddafter}}|{{#var:ddafter}}|{{#var:ddafter1}}{{#var:ddafter2}}}}
    tables=Persona
    |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | +6 week}}'
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
}}
</div></small>
</div></small>
<!--
<!--
Строка 65: Строка 140:
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}-->
}}-->[[Категория:Даты]]

Текущая версия от 09:49, 16 января 2024

Дни рожденияПравить

Дни памятиПравить

Источник — https://bard-wiki.net/index.php?title=Дни_рождения&oldid=12486