Difference between revisions of "Home/ask/assignments"
(changed lookups to use the #time parser function to automatically perform the necessary date calculates from the time the page was refreshed) |
(Change limit to x20 games) |
||
Line 3: | Line 3: | ||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
− | <p>''' | + | <p>'''Last 10 released:'''</p> |
</div> | </div> | ||
<table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> | <table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> | ||
Line 9: | Line 9: | ||
tables=Assignments | tables=Assignments | ||
|fields=Game,Status,Release_Date | |fields=Game,Status,Release_Date | ||
− | |where=DATEDIFF(Release_Date, '{{#time: Y-m- | + | |where=DATEDIFF(Release_Date, '{{#time: Y-m-d | now }}') < 0 |
|format=template | |format=template | ||
|template=:Home/ask/assignments/row | |template=:Home/ask/assignments/row | ||
|order by=Release_Date ASC | |order by=Release_Date ASC | ||
+ | |limit=10 | ||
|more results text= | |more results text= | ||
}} | }} | ||
</table> | </table> | ||
</div> | </div> | ||
− | |||
− | |||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
− | <p>'''Next | + | <p>'''Next 10 upcoming:'''</p> |
</div> | </div> | ||
<table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> | <table style="max-width: 100%; min-width: 100%; margin: 0 auto; border: 0; border-spacing: 0 10px;"> | ||
Line 28: | Line 27: | ||
tables=Assignments | tables=Assignments | ||
|fields=Game,Status,Release_Date | |fields=Game,Status,Release_Date | ||
− | |where=DATEDIFF(Release_Date, '{{#time: Y-m- | + | |where=DATEDIFF(Release_Date, '{{#time: Y-m-d | now }}') >= 0 |
|format=template | |format=template | ||
|template=:Home/ask/assignments/row | |template=:Home/ask/assignments/row | ||
|order by=Release_Date ASC | |order by=Release_Date ASC | ||
+ | |limit=10 | ||
|more results text= | |more results text= | ||
}} | }} | ||
Line 37: | Line 37: | ||
</div> | </div> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
</div><noinclude>{{Documentation}}</noinclude> | </div><noinclude>{{Documentation}}</noinclude> |
Revision as of 21:15, 13 October 2019
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.