Difference between revisions of "Home/ask/assignments"
m (fixed closing the last div) |
m (new styling) |
||
Line 3: | Line 3: | ||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
− | <p>April</p> | + | <p>'''April'''</p> |
</div> | </div> | ||
− | <table | + | <table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> |
{{#cargo_query: | {{#cargo_query: | ||
tables=Assignments | tables=Assignments | ||
Line 11: | Line 11: | ||
|where=DATEDIFF(Release_Date, '2019-04-01') >= 0 AND DATEDIFF(Release_Date, '2019-05-01') < 0 | |where=DATEDIFF(Release_Date, '2019-04-01') >= 0 AND DATEDIFF(Release_Date, '2019-05-01') < 0 | ||
|format=template | |format=template | ||
− | |template=: | + | |template=:User:Aemony/Sandbox/Assignments/row |
|limit=10 | |limit=10 | ||
|order by=Release_Date ASC | |order by=Release_Date ASC | ||
Line 21: | Line 21: | ||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
− | <p>May</p> | + | <p>'''May'''</p> |
</div> | </div> | ||
− | <table | + | <table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> |
{{#cargo_query: | {{#cargo_query: | ||
tables=Assignments | tables=Assignments | ||
Line 29: | Line 29: | ||
|where=DATEDIFF(Release_Date, '2019-05-01') >= 0 AND DATEDIFF(Release_Date, '2019-06-01') < 0 | |where=DATEDIFF(Release_Date, '2019-05-01') >= 0 AND DATEDIFF(Release_Date, '2019-06-01') < 0 | ||
|format=template | |format=template | ||
− | |template=: | + | |template=:User:Aemony/Sandbox/Assignments/row |
|limit=10 | |limit=10 | ||
|order by=Release_Date ASC | |order by=Release_Date ASC | ||
Line 39: | Line 39: | ||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
− | <p>June</p> | + | <p>'''June'''</p> |
</div> | </div> | ||
− | <table | + | <table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> |
{{#cargo_query: | {{#cargo_query: | ||
tables=Assignments | tables=Assignments | ||
Line 47: | Line 47: | ||
|where=DATEDIFF(Release_Date, '2019-06-01') >= 0 AND DATEDIFF(Release_Date, '2019-07-01') < 0 | |where=DATEDIFF(Release_Date, '2019-06-01') >= 0 AND DATEDIFF(Release_Date, '2019-07-01') < 0 | ||
|format=template | |format=template | ||
− | |template=: | + | |template=:User:Aemony/Sandbox/Assignments/row |
|limit=10 | |limit=10 | ||
|order by=Release_Date ASC | |order by=Release_Date ASC |
Revision as of 22:49, 31 May 2019
April
03 | Totally Accurate Battle Simulator | |
03 | Photographs | |
05 | Feather | |
07 | Risk of Rain 2 | |
15 | Train Valley 2 | |
15 | One Finger Death Punch 2 | |
16 | Anno 1800 | |
16 | World War Z | |
23 | Mortal Kombat 11 | |
25 | Imperator: Rome |
May
Description
- Purge the home page to refresh the lists.
This page makes use of the #cargo_query function along with relevant #time parser function to query data from the Assignments
Cargo table (populated by the the Assignments/Table page) which is then transcluded unto Home. As part of the database query, the query makes use of the DATEDIFF() function to validate if the specified Release Date
(also set on the the Assignments/Table page) is between two dates, the first day of the month or the first day of the next month.
- The two future months listed first are ordered by the release date in ascending order. The bottom past month is ordered in descending order.