Difference between revisions of "Home/ask/assignments"
m (Removed limits entirely) |
m (rearranged months so that oldest is on bottom) |
||
Line 3: | Line 3: | ||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
− | <p>''' | + | <p>'''June'''</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, '2019- | + | |where=DATEDIFF(Release_Date, '2019-06-01') >= 0 AND DATEDIFF(Release_Date, '2019-07-01') < 0 |
|format=template | |format=template | ||
|template=:Home/ask/assignments/row | |template=:Home/ask/assignments/row | ||
Line 20: | Line 20: | ||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
− | <p>''' | + | <p>'''July'''</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 26: | Line 26: | ||
tables=Assignments | tables=Assignments | ||
|fields=Game,Status,Release_Date | |fields=Game,Status,Release_Date | ||
− | |where=DATEDIFF(Release_Date, '2019- | + | |where=DATEDIFF(Release_Date, '2019-07-01') >= 0 AND DATEDIFF(Release_Date, '2019-08-01') < 0 |
|format=template | |format=template | ||
|template=:Home/ask/assignments/row | |template=:Home/ask/assignments/row | ||
Line 34: | Line 34: | ||
</table> | </table> | ||
</div> | </div> | ||
+ | |||
+ | <hr style="width: 50%; margin: 0 auto; border: 1px none dotted #333"> | ||
<div class="month-container"> | <div class="month-container"> | ||
<div class="month"> | <div class="month"> | ||
− | <p>''' | + | <p>'''May'''</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 43: | Line 45: | ||
tables=Assignments | tables=Assignments | ||
|fields=Game,Status,Release_Date | |fields=Game,Status,Release_Date | ||
− | |where=DATEDIFF(Release_Date, '2019- | + | |where=DATEDIFF(Release_Date, '2019-05-01') >= 0 AND DATEDIFF(Release_Date, '2019-06-01') < 0 |
|format=template | |format=template | ||
|template=:Home/ask/assignments/row | |template=:Home/ask/assignments/row |
Revision as of 16:19, 3 June 2019
June
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] |
July
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] | |
29 | [[]] |
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.