мНет описания правки
Метка: отменено
мНет описания правки
 
(не показано 50 промежуточных версий 2 участников)
Строка 1: Строка 1:
<small>__NOCACHE__
<small>__NOCACHE__<!--{{#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: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
     tables=Persona
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') BETWEEN DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 6 WEEK), '%m-%d') AND DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 1 YEAR), '%m-%d')
     |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')
     |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
     |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}
    |default=   
</div>
}}}}{{#vardefine:dbbefore2|{{#cargo_query:
<!--'''{{#time: d.m.Y}}'''-->
----
<div style="line-height: 1.1;">
{{#cargo_query:
     tables=Persona
     tables=Persona
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') BETWEEN DATE_FORMAT(CURDATE(), '%m-%d') AND DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL 6 WEEK), '%m-%d')
     |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')
     |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
     |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}
    |default=   
 
}}}}{{#vardefine:ddbefore|{{#cargo_query:
</div>
 
== Дни памяти ==
<div style="line-height: 1.1;">
{{#cargo_query:
     tables=Persona
     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}}'
     |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d | -6 week}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | -1 day}}'
Строка 34: Строка 91:
     |format=template
     |format=template
     |template=DateDeath
     |template=DateDeath
}}
    |default=   
</div>
}}}}{{#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')
<div style="line-height: 1.1;">
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
{{#cargo_query:
    |format=template
    |template=DateDeath
    |default=   
}}}}{{#vardefine:ddbefore2|{{#cargo_query:
     tables=Persona
     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}}')
     |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')
     |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
     |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
     |format=template
     |format=template
     |template=DateDeath
     |template=DateDeath
}}
    |default=   
}}}}
== Дни рождения ==
<div style="line-height: 1.1;">
{{#if: {{#var:dbbefore}}|{{#var:dbbefore}}|{{#var:dbbefore1}}{{#var:dbbefore2}}}}<!--
{{#var:dbbefore1}}{{#var:dbbefore2}}-->
</div>
<!--'''{{#time: d.m.Y}}'''-->
----


<div style="line-height: 1.1;">
{{#if: {{#var:dbafter}}|{{#var:dbafter}}|{{#var:dbafter1}}{{#var:dbafter2}}}}
</div>
== Дни памяти ==
<div style="line-height: 1.1;">
{{#if: {{#var:ddbefore}}|{{#var:ddbefore}}|{{#var:ddbefore1}}{{#var:ddbefore2}}}}
</div>
----
<div style="line-height: 1.1;">
{{#if: {{#var:ddafter}}|{{#var:ddafter}}|{{#var:ddafter1}}{{#var:ddafter2}}}}
</div></small>
</div></small>
<!--
<!--
Строка 58: Строка 140:
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}-->
}}-->[[Категория:Даты]]

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

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


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