Difference between revisions of "Home/ask/assignments"
m (removed infoxbox game dependency) |
m (changed to using datediff) |
||
Line 1: | Line 1: | ||
− | <div class="container-pcgwikitable"><table class="pcgwikitable sortable template-infotable" id="table-availability" style="max-width: 100%; min-width: 100%; margin: 0 auto"> | + | <div class="container-pcgwikitable"> |
+ | |||
+ | <div class="month-container"> | ||
+ | <div class="month"> | ||
+ | <p>May</p></div> | ||
+ | <table class="pcgwikitable sortable template-infotable" id="table-availability" style="max-width: 100%; min-width: 100%; margin: 0 auto"> | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Assignments | tables=Assignments | ||
− | |fields= | + | |fields=Game,Status,Release_Date |
− | |where= | + | |where=DATEDIFF(Release_Date, '2019-04-01') >= 0 AND DATEDIFF(Release_Date, '2019-04-30') <= 0 |
|format=template | |format=template | ||
|template=:Home/ask/assignments/row | |template=:Home/ask/assignments/row | ||
|limit=10 | |limit=10 | ||
− | |order by= | + | |order by=Release_Date DESC |
|more results text= | |more results text= | ||
}} | }} | ||
− | </table></div> | + | </table> |
+ | </div> | ||
+ | </div> | ||
+ | |||
+ | <div class="month-container"> | ||
+ | <div class="month"> | ||
+ | <p>May</p></div> | ||
+ | <table class="pcgwikitable sortable template-infotable" id="table-availability" style="max-width: 100%; min-width: 100%; margin: 0 auto"> | ||
+ | {{#cargo_query: | ||
+ | tables=Assignments | ||
+ | |fields=Game,Status,Release_Date | ||
+ | |where=DATEDIFF(Release_Date, '2019-05-01') >= 0 AND DATEDIFF(Release_Date, '2019-05-31') <= 0 | ||
+ | |format=template | ||
+ | |template=:Home/ask/assignments/row | ||
+ | |limit=10 | ||
+ | |order by=Release_Date DESC | ||
+ | |more results text= | ||
+ | }} | ||
+ | </table> | ||
+ | </div> | ||
+ | </div> | ||
+ | |||
+ | <div class="month-container"> | ||
+ | <div class="month"> | ||
+ | <p>June</p></div> | ||
+ | <table class="pcgwikitable sortable template-infotable" id="table-availability" style="max-width: 100%; min-width: 100%; margin: 0 auto"> | ||
+ | {{#cargo_query: | ||
+ | tables=Assignments | ||
+ | |fields=Game,Status,Release_Date | ||
+ | |where=DATEDIFF(Release_Date, '2019-06-01') >= 0 AND DATEDIFF(Release_Date, '2019-06-30') <= 0 | ||
+ | |format=template | ||
+ | |template=:Home/ask/assignments/row | ||
+ | |limit=10 | ||
+ | |order by=Release_Date DESC | ||
+ | |more results text= | ||
+ | }} | ||
+ | </table> | ||
+ | </div> | ||
+ | </div> | ||
+ | |||
+ | <div> |