мНет описания правки
Метка: отменено
мНет описания правки
 
(не показана 41 промежуточная версия 2 участников)
Строка 1: Строка 1:
<small>__NOCACHE__
<small>__NOCACHE__<!--{{#vardefine:dbafter|{{#cargo_query:
    tables=Persona
    |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%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.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
    |default=
}}}}{{#vardefine:dbafter2|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '12-31') OR (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:dbafter|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%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.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
    |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d | -6 week}}' AND DATE_FORMAT(Persona.DateBirth, '%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.DateBirth, '%m-%d') ASC
    |format=template
    |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;">
<div style="line-height: 1.1;">
{{#cargo_query:
{{#if: {{#var:dbbefore}}|{{#var:dbbefore}}|{{#var:dbbefore1}}{{#var:dbbefore2}}}}<!--
tables=Persona
{{#var:dbbefore1}}{{#var:dbbefore2}}-->
|fields=Persona._pageName, DATE_FORMAT(STR_TO_DATE(Persona.DateBirth, '%d.%m.%Y'), '%d.%m.%Y'), DATE_FORMAT(STR_TO_DATE(Persona.DateDeath, '%d.%m.%Y'), '%d.%m.%Y')
|where=STR_TO_DATE(Persona.DateBirth, '%d.%m.%Y') BETWEEN DATE_SUB(CURDATE(), INTERVAL 6 WEEK) AND CURDATE()
|order by=STR_TO_DATE(Persona.DateBirth, '%d.%m.%Y') ASC
|format=template
|template=DateBirth
|default=
}}
 
</div>
</div>
<!--'''{{#time: d.m.Y}}'''-->
<!--'''{{#time: d.m.Y}}'''-->
----
----
<div style="line-height: 1.1;">
<div style="line-height: 1.1;">
{{#cargo_query:
{{#if: {{#var:dbafter}}|{{#var:dbafter}}|{{#var:dbafter1}}{{#var:dbafter2}}}}
tables=Persona
|where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= DATE_FORMAT(CURDATE(), '%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=
}}
{{#cargo_query:
tables=Persona
|where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '01-01' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 6 WEEK), '%m-%d')
|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=
}}


</div>
</div>
Строка 39: Строка 124:
== Дни памяти ==
== Дни памяти ==
<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>


Строка 52: Строка 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') <= '12-31') OR (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
}}
 
</div></small>
</div></small>
<!--
<!--
Строка 70: Строка 140:
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}-->
}}-->[[Категория:Даты]]

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

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


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